Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do I have a compatability issue here,,,
I have two versions (2 seperate files) of the same file.
When I load V20 using xl2003 everything works fine. In my VBE - Tools, References I only show (checked): 1) VBA 2) Excel 11.0 Obj Lib 3) OLE Automation 4) MSO 11.0 Obj Lib 5) MS Outlook 12.0 Obj Lib (I do not have OL V11 loaded - I use only OL 12) When I load V31 using xl2003 - it loads - Going immediately to VBE -- Tools References I see (Checked) 1) VBA 2) Excel 11.0 Obj Lib 3) OLE Automation 4) MSO 11.0 Obj Lib 5) MS Forms 2.0 Obj Lib 6) MS Outlook 12.0 Obj Lib (I do not hane OL V11 loaded - I use only OL 12) When I run a macro involving Outlook on my V20 -- everyhting works When I run a macro involving Outlook on my V31 -- Suddenly I get the dreaded message Miscrosoft Excel has stopped working << equivalent to a crash!!! Before running in V31 I tried Unchecking the Forms 2.0 (per the above), but get the message "Can't remove control or refernce in use" <<< hummmm... Any ideas what's going on and how I can correct the problem - I need for V31 to not crash, TIA, Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do I have a compatability issue here,,,
Your may want to start excel in Safe mode. Set your security level to medium
from worksheet Tools - Macro - Security - Medium. Then open the V31 file with macros disabled. Try to remove the 2.0 forms reference. If this doesn't work try remving your forms one at time until you isolate the problem. First Export the form in the VBA Explorer window by right click form and and select Delete. Answer yes that you want to export before deleting. Once you located which form is causing the problem then exported file is a text file which you may be able to find the problem. A quicker solution mabe to create a nw workbook and add the forms one at a time. First select all the worksheets by clicking on 1sr worksheet. then scroll to last worksheet and hold the SHIFT key while selecting the last worksheet. Next right click one of the tabs that are selected and select Move Copy. From the Move copy menu check the copy box and in the pulldown menu select New Wrokbook. This will copy all the worksheets. then add the forms using the Import Form by right clicking Forms in the VBA explorer window and select import. "JMay" wrote: I have two versions (2 seperate files) of the same file. When I load V20 using xl2003 everything works fine. In my VBE - Tools, References I only show (checked): 1) VBA 2) Excel 11.0 Obj Lib 3) OLE Automation 4) MSO 11.0 Obj Lib 5) MS Outlook 12.0 Obj Lib (I do not have OL V11 loaded - I use only OL 12) When I load V31 using xl2003 - it loads - Going immediately to VBE -- Tools References I see (Checked) 1) VBA 2) Excel 11.0 Obj Lib 3) OLE Automation 4) MSO 11.0 Obj Lib 5) MS Forms 2.0 Obj Lib 6) MS Outlook 12.0 Obj Lib (I do not hane OL V11 loaded - I use only OL 12) When I run a macro involving Outlook on my V20 -- everyhting works When I run a macro involving Outlook on my V31 -- Suddenly I get the dreaded message Miscrosoft Excel has stopped working << equivalent to a crash!!! Before running in V31 I tried Unchecking the Forms 2.0 (per the above), but get the message "Can't remove control or refernce in use" <<< hummmm... Any ideas what's going on and how I can correct the problem - I need for V31 to not crash, TIA, Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell 2007 / 2003 Compatability Issue | Excel Worksheet Functions | |||
Compatability checker | Excel Discussion (Misc queries) | |||
Compatability mode | Excel Discussion (Misc queries) | |||
Backward compatability | Excel Programming | |||
Compatability | Excel Programming |