Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error 1004
I was told the following about a macro I built: If you build a large portion of your macros with the macro recorder in a newer version of Excel, then the code will use the "new" arguments which will cause problems in older versions. I was getting a run-time error 1004, when the file was opened in an older version of Excel. Is there a solution to change this file so it will work with older versions when opened
Thank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error 1004
You need to manually change the offending code so that it will
work in earlier versions. There is no way to record a macro to produce code guaranteed to be compatible with earlier versions. Also, there is no way to automatically change code to be compatible with earlier versions. It is strictly a manual process. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "meagain" wrote in message ... I was told the following about a macro I built: If you build a large portion of your macros with the macro recorder in a newer version of Excel, then the code will use the "new" arguments which will cause problems in older versions. I was getting a run-time error 1004, when the file was opened in an older version of Excel. Is there a solution to change this file so it will work with older versions when opened? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error 1004
Thanks, but Im not sure what you mean by manually change the offending code
Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error 1004
You have to go in to the recorded code and change the code so
that it will work with earlier versions. You must do it yourself; there is no automatic way to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "meagain" wrote in message ... Thanks, but Im not sure what you mean by manually change the offending code? Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error 1004
Are you saying I go into the code a type the same thing in as is there and erase the old?
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error 1004
No. If you have recorded code that works in Excel 2002, for
example, but not in Excel 2000 or another earlier version, you need to modify the Excel 2002 code so that it will run in the earlier version. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "meagain" wrote in message ... Are you saying I go into the code a type the same thing in as is there and erase the old? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run time error 1004 | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Run-time error 1004 | Excel Programming | |||
Run-Time error '1004' | Excel Programming |