Renaming file with imbedded formula with VB

[CharlotteFixedIncome]

Hello everyone -

Longtime lurker, first time poster. I'm fairly new to VB and have reached a point where I've exhausted my abilities.

I'm trying to automate a few processes for work and have been successful in doing so... other than the fact that the file name portion of the exercise is not automated.

Here's a quick excerpt from the code I have thus far:

"C:\Documents and Settings\randomname\Desktop\spreadsheet_20110814_2.csv"

I need this to say the same thing but rather than 20110814 - I want to insert the Today() function. That way it saves as the current date every time i run the macro.

I've searched and searched and cannot come up with how to name a file with an embedded formula. Any suggestions? Thanks!

CharlotteFI

 

[Warship]

filePath = "C:\Documents and Settings\randomname\Desktop\spreadsheet_" & Format(Date, "yyyymmdd") & ".csv"

 

[CharlotteFixedIncome]

Thanks, Warship! Works perfectly. I appreciate the quick turnaround.

 

[Warship]

You're welcome.
BTW - Glad you finally poked your head in...