Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A little help with SaveAs Method please
I have a VBA macro that opens a selected CSV file and executes. What is the
code required to make the macro save the CSV file as an Excel Workbook, with the same name and in the same location? Appreciate the help thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A little help with SaveAs Method please
Stitch,
Using the macro recorder and then modifying, I got this. It assumes the book your saving is the activeworkbook: Sub Test() ActiveWorkbook.SaveAs Filename:= _ Replace(LCase(ActiveWorkbook.Name), "csv", "xls"), FileFormat:=xlNormal _ , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub hth, Doug "Stitch45" wrote in message ... I have a VBA macro that opens a selected CSV file and executes. What is the code required to make the macro save the CSV file as an Excel Workbook, with the same name and in the same location? Appreciate the help thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using SaveAs method | Excel Discussion (Misc queries) | |||
SaveAs method error | Excel Discussion (Misc queries) | |||
Difficulties with SaveAs method | Excel Programming | |||
Question Using SaveAs Method | Excel Programming | |||
SaveAs method | Excel Programming |