| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro save as delete original file
I would like to write a macro to save a file to a different folder location,
same filename, and then delete the file from the original location. I tried record macro and went to file-open to do the delete file part (right click on file and delete), but the file didn't delete. In visual basic, the command recorded was ChDir and the filename. Any help would be appreciated. Pam |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Macro to Open File, Delete Contents, Save New File | Excel Discussion (Misc queries) | |||
| rename current file save and delete original | Excel Programming | |||
| auto save excel file every 10 minutes to its original file name | Excel Discussion (Misc queries) | |||
| Auto save replaced my original file and now I need the original? | Excel Discussion (Misc queries) | |||
| VBA to Save a file to a different format but keep original | Excel Programming | |||
Threaded Mode
