One addition....
I see that the problem is with the path.
The fname variable is based on path + name: c:/as/sd/filename.
When I change the fname to filename' the code is running perfect and save
the csv file in the default folder.
Again in excel 2003 it runs perfect as is. the problem is in office 2007 only.
thanks again

"Lp12" wrote:

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