I have a set of macros that are used for company standard documents.
The Macro's are in an .xla file that I need to have reside on the
server as 100+ people will be using the documents that reference these
macros.

I'm trying to come up with a function that will give me the number of working
days between two dates.  Unless I'm missing something WORKDAYS and
NETWORKDAYS will not work because Saturday is considered a workday.
I came up with a UDF that works fine for two dates that are less ...

hi
i have erorr on my email on yahoo why?

I am trying to write a macro that changes the cell colour in a range of cells
based on the cell colour in the row.

I was wondering if there is a add-in out there that enable you to draw lines
& shapes on a form?
Any answer would be greatly appreicated
Jason

I am going to have multiple values in column B (they will not be the same
every time) that look like the following
A                B        C....
Apple       328         ...

Hi everyone:  This is probably an easy question, but I have a column
for notes in excel 2000.  I want the user to be able to enter in a few
dozen letters maybe a hundred at the most but I don't want the text to
spill out beyond the length of the column which is 25 and I don't want

now I open the file and copy it to another file line by line and
change lines need to be changed.
Is there an easy way? It looks like an INI file but not really is a
INI file.

Using Office 2003
I’m creating an Excel file to upload a few thousand text clinic notes
previously written in Word to an EMR system. On the Excel end I need a
separate record for the patient name, Med number, date of service and the

I recorded a macro while editing a bitmap and the macro in the VBA
Editor is empty.
I tried to perform other actions like entering some text in some cells
and those actions are recorded.

greetings, am using Application.WorksheetFunction.Match, using 0 - for exact
match, comparing two ranges (one in sheet1, other sheet2).  i want to
highlight the columns of range in sheet2 which are not included in range in
sheet1.  running into problem, i think, because when ...

is it posible to send only link in outlook without sending the all
worksheet as well via vba

Have sub below that is used to get data from closed workbook (i.e., the
source file); it actually opens the file in read-only then closes again; it
works great.  However, I can’t seem to integrate into it code to check to see
if the file which the user selects in the file dialog ...

Hi ....
Please help me wi this problem.......The users need to see the print preview
form... but into print preview form i need to disable the print button.
the another print options is in the (menu view) page break preview. The

I want to use VBA to connect to a SQL server and run a SQL command that will
return data to a pivot table.  The SQL command will be generated based on a
date range entered into a couple of cells (at least that is my first thought
on how to do this).  My goal is to have the user ...