LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
this code makes excel crash zz Excel Programming 0 December 22nd 06 11:14 PM
XLA makes XL2003 crash Soren[_2_] Excel Programming 3 September 27th 05 01:40 PM
XLA makes XL2003 crash Soren[_2_] Excel Programming 0 September 26th 05 09:31 AM
Failed userform loading and cause application crash noiseash Excel Programming 1 August 25th 05 03:35 PM
Application.Quit en Excel crash Jos Vens[_2_] Excel Programming 4 April 8th 05 01:27 PM


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"