VBA SaveAs function generates blank CSV file

[Shaoqing Chen]

This is a very simple line and it just doesn't work. What it did is just creating a blank csv file with nothing in it (the file name is correct though).


ActiveWorkbook.SaveAs Filename:="C:\temp\test" & ".csv", _
FileFormat:=xlCSV, CreateBackup:=False


And it only happens on one PC. The other PCs runs it perfectly. Can anyone tell why?

 

[Tim Williams (Theravance)]

All PC's are the same version of Excel? It's possible that on the
problem PC the active workbook is not what you think it is...

Tim

 

[sqchen]

I am not sure what you mean. I tried restarting excel and only opening one workbook and it was still the same thing.

 

[Dave Peterson]

Saving a workbook as a CSV file saves only the activesheet.

Maybe the sheet that's active is empty?

 

[sqchen]

No it definitely was not empty. The save to xsl worked fine.

The most stupid thing is, after this line executed I can see the title of the workbook changed to test.csv with full data in it. But when I get out of excel and open the file with notepad it is all empty.