Excel will give the number of days between two given dates, provided both
are post 1/1/1900.
For Family History research, I would like to obtain the time between dates
for periods going back to the 1600s !

I have created an AddIn Library comprising quite a few different modules.
Yes, I know I can export the text of a module into a *.bas file - but is
there any way that I can export them all "at one stroke" ?
Regards

I need some coding for the following:
I have a workbook titled "ALL Trend Log" that does trend calculations for
me. I manually enter the data to calculate from another workbook and want to
make this automated.

Good morning all,
Cannot figure out what I am missing here.
This is in cell F6
='VT by Brand 07-09'!S7

I have Workbook-A with worksheets 'Sheet1' and 'Sheet2'.  I also have
Workbook-B with 'Sheet1' and 'Sheet2'.  
I want to replace Workbook-B's Sheet2 with Workbook-A's Sheet2.  
Workbook-B's Sheet2 must retain the same worksheet name because there are

From the msword forum I see a reference to
http://www.word.mvps.org/FAQs/Customization/AsgnCmdOrMacroToToolbar.htm,
which shows a way to add an item to the right click menu or what seems to be
more properly called shortcut menu.

Why won't this or any other way I have tried to write this line work?
Set x = rng.Subtotal(groupby:=1, Function:=xlSum)
Argument not optional  error
Dim x as long

I would like to use some of the functionality of the Windows Scripting Host
in a macro in Excel 2002.  How would I go about referencing it in my macro?

While I know how to find blank cells and delete complete rows, how do I
find all the blank cells in column C and clear the cell contents of the
next 5 cells to the right?
Grateful for some advice.

I thought posting a suggestion to Microsoft (see Mouse Scroll event in
listbox kills Excel) would do it, but I see suggestions are just a political
events.  I would try to rattle their cage with a bug posting.  Is there a
formal way to report bugs?

   I would like to know if there is a clean way to read files created
under unix ( so terminating by LF instead if CRLF on Windows) in VBA.
It seems that when i call "Line Input" , i get the full file at once .
Would it be possible to get it line by line?

Hi I am trying to remove the pivot commandbar from the right click menu, can
someone tell if this is possible. I have looked at
Application.CommandBars("PivotTable").Visible = False I thought about putting
this in the worksheet load module.

I have a form that has the following code. It works on my computer but now
that i want to let someone else use this. When they run the form it gets
errors. I think she said syntax error. Is there anything i can do to fix this
problem without changing the form or the code? ...

Could somebody please explain why this macro will not hide/unhide rows
57:59?  The macro fires correctly, runs through the If statements
correctly but does not hide/unhide the rows in the second range.  The
first range works perfectly.

Hello, could anyone please help. I have a macro which will pull the URL
address from the excel sheet and open the website then extract the data from
it. (using for loop) I am running into a problem, where a pop up Security
Alert window will appear when excel try to open some URL. ...