| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to open most current file in folder
Is there a way for a Macro to open the most current file in a folder? I have
a file copied to a specified folder nightly (C:\DLY\PB061807.txt) for example. The PB stays the same in every file, and then it adds the date to the end. There may be several in the folder(for example over the weekend, on Monday there will be three files), but I am setting up a macro to run each night and process the text file, but I need to find out how to get it to open the most current file. Help??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word and Excel crash when I try to open a folder to get to a file | Excel Discussion (Misc queries) | |||
| Unable to open a file from its icon in folder | Excel Discussion (Misc queries) | |||
| Macro syntax to open file in current explorer folder | Excel Discussion (Misc queries) | |||
| I can't open an xls.file compressed(zipped)folder in Windows XP? | Excel Discussion (Misc queries) | |||
| Excel should open documents in the folder of the current file | Setting up and Configuration of Excel | |||
Threaded Mode
