| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that opens an xls file then saves it with another name
I just want to be able to call an existing excel file, junk.xls, then
save it as notjunk.xls. Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro that opens an xls file then saves it with another name
No need to open to rename. Look in the vba help index for NAME
-- Don Guillett Microsoft MVP Excel SalesAid Software "Captain Snuggles" wrote in message ... I just want to be able to call an existing excel file, junk.xls, then save it as notjunk.xls. Any ideas? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro that opens an xls file then saves it with another name
I think this will work.
Sub Vert() myPath = ThisWorkbook.Path Set wb = Workbooks.Open Filename:=myPath & "\junk.xls" wb.SaveAs filename:="notjunk.xls" End Sub "Captain Snuggles" wrote: I just want to be able to call an existing excel file, junk.xls, then save it as notjunk.xls. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File opens another file runs macro and closes | Excel Programming | |||
| building a macro that saves a file and converts to pdf | Excel Programming | |||
| Macro that saves Excel worksheet with value in C4 as the file name | Excel Programming | |||
| Recorded macro opens, converts comma-del file and saves | Excel Programming | |||
| button that opens open dialogs but saves path to sheet | Excel Programming | |||
Linear Mode
