View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bdra Bdra is offline
external usenet poster
 
Posts: 4
Default 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!