Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error transporting excel 2007 macro to excel 2003.
I have writen a macro and userform in excel 2007. I saved it as excel
97-2003 format. its working fine in all machines which has excel 2007 but not in excel 2003. I am getting "object doesn't support this method or property" on frm.show. What could be the problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error transporting excel 2007 macro to excel 2003.
Check the references to the object model, if Excel 2007 installed then the
object model for will be referencing version 12, you need version 11 when running in Excel 2003. Goto VBE - tools-References to check and change. Also try turning 'break on all errors' in error handling (VBE-tools-options-general-tab) this will allow the error on the form to appear not just the generic unable to load form in case there is something else on the form causing the problem. -- Regards, Nigel "Yajiv" wrote in message ... I have writen a macro and userform in excel 2007. I saved it as excel 97-2003 format. its working fine in all machines which has excel 2007 but not in excel 2003. I am getting "object doesn't support this method or property" on frm.show. What could be the problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink error from Excel 2003 to Word 2007 | Links and Linking in Excel | |||
Error on a excel 2003 file to open in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Excel 2003 converted to 2007 copying worksheet error | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |