View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shaoqing Chen Shaoqing Chen is offline
external usenet poster
 
Posts: 1
Default 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?