| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Error
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. -- Thanks for your help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Error
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. -- Kevin Backmann "LesHurley" wrote: 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. -- Thanks for your help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Error
Nope; Still does the same thing. I will take a look at the link you gave me
in your PS. -- Thanks for your help "Kevin B" wrote: 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. -- Kevin Backmann "LesHurley" wrote: 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. -- Thanks for your help |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Error
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. -- Thanks for your help "Kevin B" wrote: 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. -- Kevin Backmann "LesHurley" wrote: 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. -- Thanks for your help |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Error
I should of included this in my prior post. Another Ready/Fire/Aim moment.
For a complete explanation regarding the XLB file go to Chip Pearson's web site at the following URL: http://www.cpearson.com/excel/StartupErrors.aspx -- Kevin Backmann "LesHurley" wrote: 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. -- Thanks for your help |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Error
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! -- Thanks for your help "Kevin B" wrote: I should of included this in my prior post. Another Ready/Fire/Aim moment. For a complete explanation regarding the XLB file go to Chip Pearson's web site at the following URL: http://www.cpearson.com/excel/StartupErrors.aspx -- Kevin Backmann "LesHurley" wrote: 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. -- Thanks for your help |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Error
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. -- Thanks for your help "LesHurley" wrote: 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. -- Thanks for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
| Downloading Templates for Excel error with a windows error. | Excel Discussion (Misc queries) | |||
Hybrid Mode
