When using the Macro “OutputTo” how can I have it saved automatically with today’s date with the title? Or can anyone direct me to a website that can help?

I'd suggest you use a module rather than a macro.
The easiest way to do it would be this:
Open your macro in design view,
choose save as, then select as Module
You may as well leave the error handling and comments boxes checked
Then open the module (which will be named something like "Converted Macro- Macro1"
The command that actually does the work is the line
Where you've got the existing filename in that line, change the code to include today's date (remembering that slashes can't be used)
So you'll start out with something along the lines of
and end up with something like:
Which will give you the filename something like D:\Stuff_20050102.xls

Next problem is calling that code.

To make it easier (and if you prefer macros to real coding), you could make another macro, with the action being "RunCode", and then select the function from there.

Steven

Steven



I am a loud man with a very large hat. This means I am in charge
(Edited due to type in code)