Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbooks - filenames change daily
I have a user who needs to open five workbooks every morning. These workbooks
are named with yesterday's date and then an alpha identifier (e.g. 111605SL). This means that the filename changes daily and not always to the previous date (e.g. today he opens yesterday's, tomorrow he opens today's, on Monday he will open Friday's). Is it even possible to write a macro to open these workbooks? Your help is appreciated. -- Thanks, GillianHG |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to Workbooks that Change Name Daily | Excel Worksheet Functions | |||
Linking to Workbooks that Change Daily | Excel Discussion (Misc queries) | |||
How to link cells in two workbooks that change daily? | Excel Discussion (Misc queries) | |||
XL97 changes filenames upon open | Excel Discussion (Misc queries) | |||
Macro to Open all workbooks in a folder and change default font | Excel Programming |