Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application makes VBE crash. How do I troubleshoot?
I have submitted an application to a client. It ran without a hitch on my
system, but alternately makes Excel and the VBE crash on the user's system. The problem is associated with the Web Browser control, which I am using. I created a crippled version of the app where the Web Browser had been removed and all Web Browser references removed from the code. This runs without a problem. The "full version will load as an Excel file, but Excel crashes the moment the user attempts to run any code. My guess is that I need to add a reference to the Web Browser control in order for the code to compile, but when I had the user reboot, load the file, and activate the VBE, the VBE immediately crashed. I had the user open the crippled version of the file, go to VBE/Tools/References and add a reference to shdocvw.dll, which is the Web Browser. Then we tried reloading the full version again, but nothing had changed. Excel crashed when we tried to run the code. I am doing this remotely, which doesn't make it easier. I am using Excel 2002 SP 3. The user has tried, with identical results, in Excel 2002 with no SP's, and in Excel 2003. Am I barking up the wrong tree -- does this sound like something other than a missing reference? Has anyone have the VBE crash like this? How do I troubleshoot from here? Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
this code makes excel crash | Excel Programming | |||
XLA makes XL2003 crash | Excel Programming | |||
XLA makes XL2003 crash | Excel Programming | |||
Failed userform loading and cause application crash | Excel Programming | |||
Application.Quit en Excel crash | Excel Programming |