Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Output to CSV
Hi,
Is there a way to create a macro to export a value (or even worksheet) to a csv file. I tried by creating a macro to save as a csv but this copies an converts the current workbook to the new file type etc. Any help would be welcome -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Output to CSV
It doesn't convert the source workbook unless you saveas with the same file
name. However, You could always copy your sheet as a new workbook, saveas CSV, then close it. Activesheet.copy Activeworkbook.Saves "C:\Myfolder\Myfile.csv", FileFormat:=xlCSV Activeworkbook.close SaveChanges:=False -- Regards, Tom Ogilvy sanjay wrote in message ... Hi, Is there a way to create a macro to export a value (or even a worksheet) to a csv file. I tried by creating a macro to save as a csv but this copies and converts the current workbook to the new file type etc. Any help would be welcome. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help for getting output | Excel Discussion (Misc queries) | |||
Output to calendar | New Users to Excel | |||
Getting output from an excel output back to cscript.. | Excel Programming | |||
Output to Notepad | Excel Programming | |||
Too much output... PLEASE HELP! | Excel Programming |