| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro that identify the newest file in a folder and open it.
hi,
i have folder that contain one new file each day. It's a text format file. The naming format is as follow: The folder is located at C:\dividend. And if today's date is jan 1 2008 then the file is dividend.yester.Jan012008.txt. So the next day, the new file would be dividend.yester.Jan022008.txt. These file only created during weekday. I have to import the content of these text file into excel each day. Is it possible to create a macro in excel that would automatically locate the most recent file and import the content automatically?? Thanks. Don |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to open most current file in folder | Excel Discussion (Misc queries) | |||
| Macro to open folder and let you chose file, then continue import | Excel Programming | |||
| Macro syntax to open file in current explorer folder | Excel Discussion (Misc queries) | |||
| using macro to open every file in a folder | Excel Programming | |||
| using macro to open every file in a folder | Excel Programming | |||
Threaded Mode
