PDA

View Full Version : Applying Title and current date to new file



Grantx
11-14-2007, 05:25 PM
The following code retrieves a specific file (010015EO.xls):

cFile = "C:\A Strategy\" & .GetSymbolInfo(SbiCode) & ".xls"

Would it be possible to retrieve this file, immediately re-name it and include the current date, eg Bobl 15 Nov 07.xls?

Thank you.

Grant.

Bob Phillips
11-14-2007, 05:27 PM
Just do a SaveAs with the updated name.