Hello again,
I am looking for macro code that will automatically insert a user-specified date (in yyyymmdd format) into an XL filename.
For instance, a typical filename would be "Reg 05_Weekly_20020209.xls" where the "Reg05_Weekly_" portion would remain constant, but the date "20020209" would have to reflect the date specified by the person running the macro. I would probably want to insert an "input Box" where the user would be prompted to enter this past Saturday's date in "yyyymmdd" format.
Any suggestions on how to pull this off?
Any assistance here would be greatly appreciated.
Thanks,
Rob
I am looking for macro code that will automatically insert a user-specified date (in yyyymmdd format) into an XL filename.
For instance, a typical filename would be "Reg 05_Weekly_20020209.xls" where the "Reg05_Weekly_" portion would remain constant, but the date "20020209" would have to reflect the date specified by the person running the macro. I would probably want to insert an "input Box" where the user would be prompted to enter this past Saturday's date in "yyyymmdd" format.
Any suggestions on how to pull this off?
Any assistance here would be greatly appreciated.
Thanks,
Rob