| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open files with a variable name in a folder get name in B1 and sav
Hi all, i need to loop through a folder and open all the "xls" files one by
one, get the name from "B1" and then save the file back to the same folder with the name obtained. Lastley I then need to delete the original file. Any help with code would be appreciated -- Les |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding files in a folder. Variable not defined error. | Excel Discussion (Misc queries) | |||
| User selection of folder and open all .xls files within folder | Excel Programming | |||
| Open files in folder - skip if already open | Excel Programming | |||
| Opening files from a variable (todays' date) folder name | Excel Programming | |||
| open all files in a folder and ... | Excel Programming | |||
Threaded Mode
