Link to home
Start Free TrialLog in
Avatar of rsernowski
rsernowskiFlag for Afghanistan

asked on

Excel Macro VBA to Append to existing file name

Hello

Looking for some Excel VBA, to pre-pend to an existing filename.  The spreadsheet comes to me with the a file name in number format  like
2015010203.xls

the file name changes daily,

so after I make my changes , i want to have excel VBA macro that prepends to the existing file name, "MAC_(then the old filename.xls)
thanks
ASKER CERTIFIED SOLUTION
Avatar of Simon
Simon
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rsernowski

ASKER

Hi Simon
Excellent , Thanks for your help