Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
1004 error when saving as CSV
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
runtime error '1004' application or object defined error. Please help | Excel Programming | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Error 1004, Application-definded or object-defined error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming |