File1 exists
File2 needs to be created (but what it will or could contain is not stated)

but you want a macro that copies from File2 (which doesn't exist).

Not sure what comment format is unless you mean you want your data to all be
text.

For me at least, you problem is too ill defined to attempt to suggest
anything.

--
Regards,
Tom Ogilvy

"alexm999 " wrote in message
...
I'm not sure if this is the right forum, but here goes:

I have an excel file that runs several macros (lets call it File1). I
need to create another file that will have "text" information that
depends on the day of the month (lets call it File2).

I'd like to create macro or VB script that will copy data from File2
and put it in File1.

Even better and heres my ultimate dream: when the data in file2 goes to
file1 it is in 'Comment' form...

Can anyone help?


---
Message posted from http://www.ExcelForum.com/