| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move file to a different folder
Erik:
That worked great. Thanks for the help. Ernie "E Oveson" wrote: The simplest way would probably be to just copy it, and then delete it from original location: FileCopy "i:\defective reports\" & SheetFileName, "i:\defective reports\processed\" & SheetFileName Kill "i:\defective reports\" & SheetFileName -Erik "ebferro" wrote in message ... I've got a short vba program that extracts data from a spreadsheet, massages the data and then puts the data into a comma delimited text file. When I'm done with the spreadsheet, I'd like to move it from the i:\defective reports\ subdirectory to the i:\defective reports\processed\ subdirectory so that I don't put the same data into my text file twice. Could anyone show me how to do this? The spreadsheet file name variable is called SheetFileName. TIA. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA to move an excel file to another folder | Excel Discussion (Misc queries) | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
| Move them to different folder | Excel Programming | |||
| Create Folder and Text File in folder | Excel Programming | |||
| Move file to different folder | Excel Programming | |||
Linear Mode
