| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move and rename a file
name "C:\Myfolder1\Myfile1.xls" as "C:\Myfolder2\Sub1\Report1.xls"
Name oldpathname As newpathname see VBA help on the Name STATEMENT. -- Regards, Tom Ogilvy "Peter" wrote: Calling all Excel programming brains, I am trying to move and rename a file but don't know where to start, can anybody help? Thanks, Peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in Any Wo | Excel Discussion (Misc queries) | |||
| Open a sheet rename and move to another workbook | Excel Programming | |||
| Rename or move file function | Excel Programming | |||
| How to set SAVE AS file name to equal A1 contents when rename file | Excel Discussion (Misc queries) | |||
| Insert sheet, move to end, rename with cell data. | Excel Discussion (Misc queries) | |||
Threaded Mode
