View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lp12 Lp12 is offline
external usenet poster
 
Posts: 54
Default 1004 error when saving as CSV

Hi All,
When running this code: ActiveWorkbook.SaveAs Filename:=fname,
FileFormat:=6, CreateBackup:=False on office 2007 Im getting the 1004 error.
On office 2003 it rus perfectly.
Even if i change the FileFormat=xlCSV, still same reaction.
Any thoughts?
Thanks a lot in advance