Excel Error

  • Thread starter Thread starter LesHurley
  • Start date Start date
L

LesHurley

When I first call any of my VBA functions from any worksheet in EXCEL I get
an error dialog that says, " Microsoft Office Excel has encountered a problem
and needs to close. We are sorry for the inconvenience". It then gives me
my choice of sending an error report or not sending. If I open the VBE with
Alt/F11 and then immediately close it, the problem goes away until the next
time I start EXCEL. Does anyone know if this is a bug, or what? This
problem didn't always occur and I haven't changed any of my VBA functions
sice long before it started. I'm using EXCEL 2003.
 
Go to the following folder, substituting the name of the folder your
documents are under for UserName in the following path:

C:\Documents and Settings\UserName\Application Data\Microsoft\Excel

If there's a file named Excel11.xlb in the Excel folder at the end of that
path delete it and seeif that doesn't fix the problem.
 
Nope; Still does the same thing. I will take a look at the link you gave me
in your PS.
 
OK Kevin; I reRegistered EXCEL according to Pearsons instructions. The
problem persists. Actually, I don't appear to have an EXCEL startup problem.
Everything works normally except for VBA. It seems very strange to me that
all I have to do tomake it work is open the VBE and immediately close it.
Wierd!
 
I posted the message below a couple of months ago and I took Kevin's advice
but still couldnt fix the problem. In the mean time I have been working with
a microsoft technical support person on another problem, which he fixed but
can't help me with this one. Does anyone have any new ideas.
 
Kevin, I just now noticed that deleting Excel11-xlb deletes my custom
toolbar. restoring the toolbar also restores that file. The problem remains
in either case.
 
Back
Top