Run time Error 91 after Application Quit

[Stephen W Allen]

I have created an Add-In downloadable over the internet. This Add-In is designed to copy itself to a User's "Microsoft/AddIns" folder and Set Installed = True. The oginal / parent Add-In then quits Excel to allow the copied version to take over functionality.

The code generates a Run time error of 91 AFTER Application.Quit has been activated. All other aspects of the process complete as expected. I cannot get a handle on the error to see what is causing it.

Any Advice?

 

[Marc L]

​

As obviously Application.Quit must be the last codeline executed …​

 

[Stephen W Allen]

​

As obviously Application.Quit must be the last codeline executed …​

That is not true in all circumstances.

For example, if you quit Excel with an unsaved workbook open, it will ask you if you want to save it. In this case the answer is 'No'.

Would it help if I provided the final If statements of the Sub routine?

 

[Marc L]

​

Give it a try with Quit as last codeline …​

 

[Stephen W Allen]

I'm sorry, I should have posted the code.

There were alternative paths to the

Application.Quit

statement: one where a

Workbook.Close Save:=FALSE

was needed and the other where there was no Workbook to close.

In fact my code tried to close the Workbook in both cases. That's what generated the error.

Problem now soved