urgent help on VBAProject-Export codes!

Andrew XJ · Mar 16th, 2002, 12:29 AM

Help....
So wrecked I am!!! The whole workbook just hang after i open it no matter by double clicking or right click->open....
There are many VBA codes in the workbook!! My backup is just work till yesterday...Is there any way that i can export the VBA codes to another place without open the workbook?????
Help....

(((

smozgur · Mar 18th, 2002, 04:37 AM

Yes, there is something to do. But is it possible to send that xls file to me? If it is not confidential of course...

suat

Andrew XJ · Mar 18th, 2002, 08:04 AM

Thx for your response!
Sorry that i can't send to your due to company's confidential policy. I have redone that. The CPU utilisation peak to 99% when i enable Macro. I know the reason may be two:
1. The auto_run executes followed by an infinite loop. Most probably because i use Application.EnableEvents=False to disable events and when Exit Sub i forget to enable events.
2. Some unknown reason regardless of my Macro. This hits me because even i disable Macros at openning, the CPU utilisation jumps to 99%.
This workbook can work yesterday. It becomes abnormal just after i add some statement Application.EnableEvents=False in some procedures.

I use Hexi Editor and Octal Editor to change all False to True. But it doesn't work. Macros are gone after save the edited file by Hex Editor.

smozgur · Mar 18th, 2002, 01:55 PM

Have you ever tried pressing Ctrl+Break when you open the workbook and just after click on the Enable Macros?

It works for lots of case to avoid accidental infinite loops in applications.

suat

Mar 16th, 2002, 12:29 AM	#1
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	Help.... So wrecked I am!!! The whole workbook just hang after i open it no matter by double clicking or right click->open.... There are many VBA codes in the workbook!! My backup is just work till yesterday...Is there any way that i can export the VBA codes to another place without open the workbook????? Help....(((

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 04:37 AM	#2
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	Yes, there is something to do. But is it possible to send that xls file to me? If it is not confidential of course... suat

Mar 18th, 2002, 08:04 AM	#3
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	Thx for your response! Sorry that i can't send to your due to company's confidential policy. I have redone that. The CPU utilisation peak to 99% when i enable Macro. I know the reason may be two: 1. The auto_run executes followed by an infinite loop. Most probably because i use Application.EnableEvents=False to disable events and when Exit Sub i forget to enable events. 2. Some unknown reason regardless of my Macro. This hits me because even i disable Macros at openning, the CPU utilisation jumps to 99%. This workbook can work yesterday. It becomes abnormal just after i add some statement Application.EnableEvents=False in some procedures. I use Hexi Editor and Octal Editor to change all False to True. But it doesn't work. Macros are gone after save the edited file by Hex Editor.

Mar 18th, 2002, 01:55 PM	#4
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	Have you ever tried pressing Ctrl+Break when you open the workbook and just after click on the Enable Macros? It works for lots of case to avoid accidental infinite loops in applications. suat