Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to Save a file to a different format but keep original
Hi,
This should not be hard, but either I am stoopid or Excel is. In VBA, I want to save a copy of my current worksheet as a CSV file and not change anything about the current workbook. It seems to me that "SaveAs filename:=whatever.csv fileformat:=xlCSV" saves the file as XLS, and converts the current file to CSV ! I have tried various work-arounds such as using SaveCopyAs or reloading the file from the original, but end up with all sorts of messes such as a CSV file containing .XLS data and my current file not being able to be written as Excel think it is a CSV file containing multiple sheets. TIA for any advice on how to do this, short of writing out the CSV data in my own code :-( Richard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to Save a file to a different format but keep original
Activesheet.Copy ' creates a new workbook for copy of current sheet.
ActiveWorkbook.SaveAs "C:\Myfile.csv",Fileformat:=xlCSV ActiveWorkbook.Close Savechanges:=False -- Regards, Tom Ogilvy "groutch" wrote in message om... Hi, This should not be hard, but either I am stoopid or Excel is. In VBA, I want to save a copy of my current worksheet as a CSV file and not change anything about the current workbook. It seems to me that "SaveAs filename:=whatever.csv fileformat:=xlCSV" saves the file as XLS, and converts the current file to CSV ! I have tried various work-arounds such as using SaveCopyAs or reloading the file from the original, but end up with all sorts of messes such as a CSV file containing .XLS data and my current file not being able to be written as Excel think it is a CSV file containing multiple sheets. TIA for any advice on how to do this, short of writing out the CSV data in my own code :-( Richard |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to Save a file to a different format but keep original
That did it - thanks Tom - Although it's a bit ugly to have a new
sheet pop up just to do this ? Don Guillett's proposed solution leaves the workbook renamed as aa1.csv, just as my attempt did, so is not a solution. Thanks, Richard |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to Save a file to a different format but keep original
You can always to
Application.ScreenUpdating = False ' sample code provided to save the file application.ScreenUpdating = True and you will not see the sheet pop up. -- Regards, Tom Ogilvy "groutch" wrote in message om... That did it - thanks Tom - Although it's a bit ugly to have a new sheet pop up just to do this ? Don Guillett's proposed solution leaves the workbook renamed as aa1.csv, just as my attempt did, so is not a solution. Thanks, Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I undo a "save file" to revert back to original spreadsheet | Excel Discussion (Misc queries) | |||
I used "save as" but now can't locate original file | Excel Discussion (Misc queries) | |||
auto save excel file every 10 minutes to its original file name | Excel Discussion (Misc queries) | |||
Auto save replaced my original file and now I need the original? | Excel Discussion (Misc queries) | |||
Any way to "Save As" without setting the archive bit on original file | Excel Programming |