Application.quit error

[Sabosis]

Hello

My code looks at a cell in my active workbook and if the value is zero, then quit. It works fine if I step through it using F8, but when the code runs through Workbook_Open, it will error out. When i hit debug, it just shuts down Excel. Any ideas?

 

[Harald Staff]

Hello

My code looks at a cell in my active workbook and if the value is zero,
then quit. It works fine if I step through it using F8, but when the code
runs through Workbook_Open, it will error out. When i hit debug, it just
shuts down Excel. Any ideas?

Not knowing your code, code that runs fine in steps but not in sequence
usually needs DoEvents inserted here and there. The word means something
like "listen to the operating system, and also wait here until the last
instruction is completed"

This said, Application.Quit is very brutal. Excel allows us to have multiple
tasks and documents open simoultaneouslly. Very few, or in real life no,
documents have the right to do shut everything down.

HTH. Best wishes Harald

 

[Martin Brown]

Hello

My code looks at a cell in my active workbook and if the value is zero, then quit. It works fine if I step through it using F8, but when the code runs through Workbook_Open, it will error out. When i hit debug, it just shuts down Excel. Any ideas?

I am not too surprised. A workbook whose own Workbook_Open action shuts
down Excel so brutally is likely to get itself into trouble by removing
services that it is still intending to use.

If it works OK in Debug but not in real life then there is some kind of
race condition between your application code and the Windows OS. These
can usually be fixed with a liberal application of DoEvents.

However, you should probably rethink your logic since users will not
thank you if Excel shuts down on them spontaneously whilst opening your
workbook and as a result junks all their unsaved work!

 

[GS]

Hello

My code looks at a cell in my active workbook and if the value is
zero, then quit. It works fine if I step through it using F8, but
when the code runs through Workbook_Open, it will error out. When i
hit debug, it just shuts down Excel. Any ideas?

Very bad practice!!!
*NEVER, NEVER, NEVER* write code that shuts down a non-automated
instance of Excel (or any other MS Office app)!!!

If startup conditions do not meet your criteria then just close your
workbook!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion