View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
glenn[_3_] glenn[_3_] is offline
external usenet poster
 
Posts: 7
Default 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!