Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing filenames using theSaveAsCopy method
Here's the problem: I would like to open a file, for instance C:\Documents and Settings\Me\Folder1\file.xls, perform some basic operations, and save it as C:\Documents and Settings\Me\Folder2\file.xls. How can I alter the filename in such a way?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing filenames using theSaveAsCopy method
Hi
in your macro use the .saveas method. e.g. try something like the following: sub foo() dim wbk as workbook workbooks.open "C:\Documents and Settings\Me\Folder1\file.xls" set wbk=activeworkbook 'perform your stuff wbk.saveas "C:\Documents and Settings\Me\Folder2\file.xls" end sub -- Regards Frank Kabel Frankfurt, Germany davidoo2005 wrote: Here's the problem: I would like to open a file, for instance C:\Documents and Settings\Me\Folder1\file.xls, perform some basic operations, and save it as C:\Documents and Settings\Me\Folder2\file.xls. How can I alter the filename in such a way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filenames ending with :1 and :2 | Excel Discussion (Misc queries) | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Please post this thread a complete correct method, method about te | New Users to Excel | |||
Changing Calculation Method | Excel Programming | |||
Method 'Run' of object '_Global' failed when changing OS and Office versions | Excel Programming |