VBA SaveAs function generates blank CSV file
 

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?

VBA SaveAs function generates blank CSV file
 

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

On Sep 29, 9:38*pm, Shaoqing Chen wrote:
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?

VBA SaveAs function generates blank CSV file
 

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

VBA SaveAs function generates blank CSV file
 

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

Maybe the sheet that's active is empty?



On 09/29/2011 23:38, Shaoqing Chen wrote:
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?

--
Dave Peterson

VBA SaveAs function generates blank CSV file
 

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.