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).
need to create another file that will have "text" information tha
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 File
and put it in File1.

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

Can anyone help

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