macro help - for a file whose name changes based on the date

[guruman]

Hi,

For archiving purposes at work we have to save files with the date at the end of them. So today, the two files that I want to include in the macro are FX020205.xls and CCFX020205.xls

Is there anyway that I can have a macro that will be directed to the folder that they will always be in, look for the beginning of the file name (so FX and CCFX) and then put the date into the 020205 format, put them together and look that up?

Any help would be much appreciated.

Thanks.

 

[Tazguy37]

Re: macro help - for a file whose name changes based on the

Sure. The filename is just a string -- add to it to your heart's content. Here's an example I use:

fName = "C:\Documents and Settings\My Documents\Yield data " & Format(Date, "mmddyyyy") & ".xls"

But you could put a cell reference in there, formula text, anything. Hope that helps!