Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet with macros that works in Excel 2003 but not in Excel
2000. In each case, Excel 2000 crashes with a failure in an object's property or method. I know this sounds like an early-binding problem, but a few things about it don't add up. First, I don't use any inter-application automation, it's all Excel. Secondly, I've written many excel macros with extensive use of early bound objects, and everything else works fine on the Excel 2000 computers in my office - only this one workbook has the problem. When a copy of the workbook is opened in Excel 2000, it seems to get progressively more corrupt as it is used. Object references which work fine the first time you run the macro can give a "Method '{method name}' of object '{object type}' failed." error the next. In a few cases, I've even seen this problem on objects declared as generic "Object" types. Any ideas as to what my problem is? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macros created in 2003 won't work in 2000 | Excel Discussion (Misc queries) | |||
Macros won't work in 2000 that are created in 2003 | Excel Discussion (Misc queries) | |||
where did my old 2000 Excel macros go when I upgraded to 2003? | Excel Discussion (Misc queries) | |||
Hyperlinks from Excel 2000 dont work anymore in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) |