Error Message!!

[Rjc8513]

Running Excel 97.

Why am I getting the error message-
"Object required (Error 424)

when running the code Application.Quit?!!!

I have used this code many times before and have
never encountered this error before.

Thanks.

Richard...

 

[DarkSun]

This may sound stupid but check the spelling of Application in your code.

Object required would suggest that it can't find the application object.

Also is that the line of code that is highlighted in debug mode?

 

[Rjc8513]

Thanks for the response.

Oddly enough if I click "End" or "Debug", Excel
then quits.

Yes, when I stepped thru the code "Application.Quit"
is the line on which the error occurs.

Application IS spelled correctly.

Richard...

 

[DarkSun]

what happens before this line?

 

[DarkSun]

Is there any code in any of the close events in the workbooks?

 

[Rjc8513]

Nothing in the Close events.

Her are the last few lines of code:

Application.DisplayAlerts = False
ActiveWorkbook.Save
Application.StatusBar = False
Application.Quit

Richard...

 

[DarkSun]

Which version of Excel are you running?
I assume this code is running from within Excel.

I was able to run the code fine in Excel 97. No problems.

What happens if you take out the Application.Quit line?

 

[Rjc8513]

I found my problem.

I have a series of User Forms/DialogSheets used as
menus. The way my code was branching created the
error.

It works now. Thanks for your help.

Richard...