1004 error when saving as CSV

L

Lp12

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
 
L

Lp12

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

Similar Threads

VBA SaveAs function generates blank CSV file 4
ActiveWorkbook.SaveAs in excel 2007 4
VB Help If Statement in Selection.ShowDetail = True 5
Save Excel file to a CSV without opening it first 4
Save as method generates 1004 error 0
User prompt for CSV format 5
Create CSV 5
problem with macros using Excel 2007 0

Top