1004 error when saving as CSV

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top