Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error '1004'
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error '1004'
Excel 2007 dropped support for that file format.
http://blogs.msdn.com/excel/archive/...24/718786.aspx -- Jim "D Huber" wrote in message ... | 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error '1004'
Hi,
Looks like the saving of this file format is no longer supported in xl2007. http://blogs.msdn.com/excel/archive/...24/718786.aspx Have you tried to save the file manually to confirm this? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "D Huber" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error '1004'
On 13 Nov, 15:14, "Jim Rech" wrote:
Excel 2007 dropped support for that file format. http://blogs.msdn.com/excel/archive/...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 :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Run time error 1004 General ODCB Error | Excel Programming |