Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in exporting to csv
hi all I wanted to export a workbook (it has only one worksheet) to a csv file, so I used this code: ActiveWorkbook.SaveAs Filename:= "c:\aFile.csv", FileFormat:=xlCSV ,CreateBackup:=False It works fine, but after I run it i find myself working in Excel within the aFile.csv file instead of the initial aFile.xls. How can I export to the csv while remaining inside the xls after the export? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in exporting to csv
After exporting,
ActiveWorkbook.SaveAs FileName:=X, _ FileFormat:=xlCSV, CreateBackup:=False ActiveWindow.Close , savechanges:=False Then you would be where you were before you added this workbook. But if you must go someplace else, you could explicitly return somewhere else: Windows("FirstFile.xls").Activate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exporting to excel problem | Excel Programming | |||
exporting to excel problem | Excel Programming | |||
Problem exporting as csv file | Excel Programming | |||
Exporting To Excel With ASP - Number Problem | Excel Programming | |||
Exporting to Excel using ASP Problem | Excel Programming |