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?