Run time Error '1004'

[Guest]

We have a macro that has typically been run in an older version of Excel that
now needs to be run in Excel 2007. Each time this is attempted we get "Run
time error '1004':" and it stops at the following line of code:

ActiveWorkbook.SaveAs Filename:= _
"P:\Freight Finance\Full Freight Allowed\dbfs\ffa.dbf" _
, FileFormat:=xlDBF4, CreateBackup:=False

Did something change in the current version of excel that would stop this
line from executing?

Thanks

 

[Jim Rech]

Excel 2007 dropped support for that file format.

http://blogs.msdn.com/excel/archive/2006/08/24/718786.aspx

--
Jim
| We have a macro that has typically been run in an older version of Excel
that
| now needs to be run in Excel 2007. Each time this is attempted we get "Run
| time error '1004':" and it stops at the following line of code:
|
| ActiveWorkbook.SaveAs Filename:= _
| "P:\Freight Finance\Full Freight Allowed\dbfs\ffa.dbf" _
| , FileFormat:=xlDBF4, CreateBackup:=False
|
| Did something change in the current version of excel that would stop this
| line from executing?
|
| Thanks

 

[Andy Pope]

Hi,

Looks like the saving of this file format is no longer supported in xl2007.
http://blogs.msdn.com/excel/archive/2006/08/24/718786.aspx

Have you tried to save the file manually to confirm this?

Cheers
Andy

 

[myemail.an]

Excel 2007 dropped support for that file format.

http://blogs.msdn.com/excel/archive/2006/08/24/718786.aspx

The sort of things you can do when you are an absolute monopolist and
users have no options but to buy your products anyway. Why bother
developing stable software or documenting its features clearly if
users are going to buy it anyway 'cos they have no real alternative?

Btw, the list is not complete: for instance, Excel 2007 no longer
supports application.filesearch ; an alternative is to use the dir()
function. If only Microsoft had at least bothered to communicate it!

Thanks, uncle Bill: may you spend all your billions in medicines