Do I have a compatability issue here,,,

[JMay]

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

 

[joel]

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.