I need a macro or something that automatically insert the file name of the
excel file into the header or footer, does not matter which, i dont need the
directory path.
Either this or  automatically insert into the header or footer the contents

I'm not actually an Excel noob, but compared to a seasoned Excel user, I
might as well be.
I'm looking at three books for Excel 2007:
1. Excel® 2007 Bible (Wiley) by John Walkenbach

I have a company roster that has names, numbers and email addresses that i
would like to put into my contacts in Microsoft outlook, can anyone help me ?
PLEASE

when i save a worksheet to a .CSV Excel uses the semicolon ";" character
as the default separator
Where do I chnage the setting so that it uses a comma "," character?
thanks

I have got a very simple accounting spreadsheet where column C is
determined by (A+B)*1.06.  Cell C is formatted for dollars - two
decimal places.  At the bottom of column C is a total which is usually
correct but sometimes it is out by one cent.  All the calculations

I am using Excel to make forms and I do not want any formulas. Even when I
choose text in the format of a cell, Excel still puts in the formula.
Example: When I type "+1% chance for 4 bolts to corrode" in a cell already
formated as text, excel still changes it to a formula. There ...

I have Worksheet 1
columnA has data like
yellow
green

Is there a formula that can convert hours in decimal into real time?
I need to convert say 2.25 hours into 2 Hours 15 Mins...
Any ideas?

I'm try to solve this problem. I have a column with 1000 numbers; from this
array I want to generate an other array with 1000-K elements that is the
result of the ratio between every element N and N+K, (for example if K=8
...B1=A1/A9, B2=A2/A10, B3=A3/A11, etc.). Now, is it ...

I need to know how to create reminders in outlook from a date cell in excel?

I have a command button that will populate in the worksheet call "Data" in
column A2 and up to 30 or more rows depending upon the workbook "Dept_Sch001
second row will be "Dept_Sch002 and so on..  I like to prevent the user to
press the command button a second time. What I want ...

I have a problem about using Pivot Table in Excel 2003:
In a pivot table I have a date field, grouped by year and month, as the row
field. The data field of the table is anything that can be summed.
Now when I tried to display the data field value as "Difference from

Need Help, sometimes when I try to select a row of cells, Excel also selects
a row or two below the row I am trying to select. What causes this problem
and what can I do about it. It only happens sometimes and at other times it
works like it is supposed to. The only way I can get ...

I have recently installed excel 2007.  I am quite accustomed to and
expert at using older versions of excel.   Is there a way that I can
set 2007 to have a more similar dialog structure to older versions, in
the way that I can set the control panel to classic view?

I need to work between 3 different excel workbooks. I enter the
location path for 2 of the workbooks in a cell and define a name for
each of them.
I can then open the workbook if the filename changed simply by