j844929
Active Member
- Joined
- Aug 18, 2002
- Messages
- 423
Hi,
Is it possible to create a button in a spreadsheet that can open a file where the date in the filename changes each day?
E.g. the file is called tradesheet200802Germany.xls and then the next will be tradesheet210802Germany.xls
Also, I'd like to know how to create a macro that saves a file in a specific location with the date contained in the file.
Hope you can help,
Kind regards,
Tim Pickop
Is it possible to create a button in a spreadsheet that can open a file where the date in the filename changes each day?
E.g. the file is called tradesheet200802Germany.xls and then the next will be tradesheet210802Germany.xls
Also, I'd like to know how to create a macro that saves a file in a specific location with the date contained in the file.
Hope you can help,
Kind regards,
Tim Pickop