Problem in exporting to csv

[glenn]

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!

 

[Guest]

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