Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA causing "Excel has encountered a problem" message
Added new VBA routine to Excel 2000 file which caused termination of Excel.
The message occurs even if disable micros or when saved as a csv file. Any other options to be able to open the file and correct the faulty VBA code? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA causing "Excel has encountered a problem" message
Did you either make a backup copy of this file or export the VBA code to a
"BAS" file? Have you tried opening up Excel only, set the security level to medium (if not already there), go into design mode, set the "Application.EnableEvents" to false (This can be done via the immediate window on the VBA side), and then open the file? Also, if you have UDFs, make sure calculation mode is set to manual before opening up the file. -- Sincerely, Ronald R. Dodge, Jr. Master MOUS 2000 "arch" wrote in message ... Added new VBA routine to Excel 2000 file which caused termination of Excel. The message occurs even if disable micros or when saved as a csv file. Any other options to be able to open the file and correct the faulty VBA code? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA causing "Excel has encountered a problem" message
Unfortunately no and no to the first question. Attmepted to perform the
Application.EnableEvents with immediate window but assume cockpit error. Not sure of exact sequence to enable that function. VBA is still new to me. I am also trying an alternate approach and having someone open with later version of Excel as I've been told it should open - all I'm after is the VBA code. Learned my lesson - will backup from now on. "Ronald Dodge" wrote: Did you either make a backup copy of this file or export the VBA code to a "BAS" file? Have you tried opening up Excel only, set the security level to medium (if not already there), go into design mode, set the "Application.EnableEvents" to false (This can be done via the immediate window on the VBA side), and then open the file? Also, if you have UDFs, make sure calculation mode is set to manual before opening up the file. -- Sincerely, Ronald R. Dodge, Jr. Master MOUS 2000 "arch" wrote in message ... Added new VBA routine to Excel 2000 file which caused termination of Excel. The message occurs even if disable micros or when saved as a csv file. Any other options to be able to open the file and correct the faulty VBA code? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA causing "Excel has encountered a problem" message
Not sure what you mean by cockpit error, but anyhow, you should only have to
type in the following line in the immediate window to disable the events in excel from being fired up when they are normally triggered: Application.EnableEvents=False There's been times when I had to set this application property to true as I'm not sure what causes it to go false, but found there has been times when the Workbook Open Event doesn't always trigger, so we were forced to use the Auto_Open sub private procedure to get around that issue. -- Sincerely, Ronald R. Dodge, Jr. Master MOUS 2000 "arch" wrote in message ... Unfortunately no and no to the first question. Attmepted to perform the Application.EnableEvents with immediate window but assume cockpit error. Not sure of exact sequence to enable that function. VBA is still new to me. I am also trying an alternate approach and having someone open with later version of Excel as I've been told it should open - all I'm after is the VBA code. Learned my lesson - will backup from now on. "Ronald Dodge" wrote: Did you either make a backup copy of this file or export the VBA code to a "BAS" file? Have you tried opening up Excel only, set the security level to medium (if not already there), go into design mode, set the "Application.EnableEvents" to false (This can be done via the immediate window on the VBA side), and then open the file? Also, if you have UDFs, make sure calculation mode is set to manual before opening up the file. -- Sincerely, Ronald R. Dodge, Jr. Master MOUS 2000 "arch" wrote in message ... Added new VBA routine to Excel 2000 file which caused termination of Excel. The message occurs even if disable micros or when saved as a csv file. Any other options to be able to open the file and correct the faulty VBA code? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA causing "Excel has encountered a problem" message
Just to add, Application.EnableEvents=False wouldn't prevent an Auto_open
routine to fire, but just hold Shift when opening. However if macros are disabled the problem might not be related to VBA code at all, perhaps something else. Regards, Peter T "Ronald Dodge" wrote in message ... Not sure what you mean by cockpit error, but anyhow, you should only have to type in the following line in the immediate window to disable the events in excel from being fired up when they are normally triggered: Application.EnableEvents=False There's been times when I had to set this application property to true as I'm not sure what causes it to go false, but found there has been times when the Workbook Open Event doesn't always trigger, so we were forced to use the Auto_Open sub private procedure to get around that issue. -- Sincerely, Ronald R. Dodge, Jr. Master MOUS 2000 "arch" wrote in message ... Unfortunately no and no to the first question. Attmepted to perform the Application.EnableEvents with immediate window but assume cockpit error. Not sure of exact sequence to enable that function. VBA is still new to me. I am also trying an alternate approach and having someone open with later version of Excel as I've been told it should open - all I'm after is the VBA code. Learned my lesson - will backup from now on. "Ronald Dodge" wrote: Did you either make a backup copy of this file or export the VBA code to a "BAS" file? Have you tried opening up Excel only, set the security level to medium (if not already there), go into design mode, set the "Application.EnableEvents" to false (This can be done via the immediate window on the VBA side), and then open the file? Also, if you have UDFs, make sure calculation mode is set to manual before opening up the file. -- Sincerely, Ronald R. Dodge, Jr. Master MOUS 2000 "arch" wrote in message ... Added new VBA routine to Excel 2000 file which caused termination of Excel. The message occurs even if disable micros or when saved as a csv file. Any other options to be able to open the file and correct the faulty VBA code? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA causing "Excel has encountered a problem" message
I thought about mentioned about EnableEvents not impacting the Auto_Open
procedure, but if macros are disabled anyhow, that would run anyways. I didn't think about the Shift key method, which I have used before, but it's been a very long time ago since I have used it. -- Sincerely, Ronald R. Dodge, Jr. Master MOUS 2000 "Peter T" <peter_t@discussions wrote in message ... Just to add, Application.EnableEvents=False wouldn't prevent an Auto_open routine to fire, but just hold Shift when opening. However if macros are disabled the problem might not be related to VBA code at all, perhaps something else. Regards, Peter T "Ronald Dodge" wrote in message ... Not sure what you mean by cockpit error, but anyhow, you should only have to type in the following line in the immediate window to disable the events in excel from being fired up when they are normally triggered: Application.EnableEvents=False There's been times when I had to set this application property to true as I'm not sure what causes it to go false, but found there has been times when the Workbook Open Event doesn't always trigger, so we were forced to use the Auto_Open sub private procedure to get around that issue. -- Sincerely, Ronald R. Dodge, Jr. Master MOUS 2000 "arch" wrote in message ... Unfortunately no and no to the first question. Attmepted to perform the Application.EnableEvents with immediate window but assume cockpit error. Not sure of exact sequence to enable that function. VBA is still new to me. I am also trying an alternate approach and having someone open with later version of Excel as I've been told it should open - all I'm after is the VBA code. Learned my lesson - will backup from now on. "Ronald Dodge" wrote: Did you either make a backup copy of this file or export the VBA code to a "BAS" file? Have you tried opening up Excel only, set the security level to medium (if not already there), go into design mode, set the "Application.EnableEvents" to false (This can be done via the immediate window on the VBA side), and then open the file? Also, if you have UDFs, make sure calculation mode is set to manual before opening up the file. -- Sincerely, Ronald R. Dodge, Jr. Master MOUS 2000 "arch" wrote in message ... Added new VBA routine to Excel 2000 file which caused termination of Excel. The message occurs even if disable micros or when saved as a csv file. Any other options to be able to open the file and correct the faulty VBA code? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding problem source causing "Your formula contains an invalid external reference to a worksheet" message | Excel Programming | |||
"Excel has encountered a problem..." error | Excel Programming | |||
can I bypass "Windows has encountered a problem" | Excel Discussion (Misc queries) | |||
XL "encountered a problem & needs to close" | Excel Programming | |||
"Microsoft Excel has encountered a problem..." | Excel Programming |