Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Nicole Hughes   on Oct 26 In MS Office Category.

  
Question Answered By: Olivia Campbell   on Oct 26

That is an interesting point - however if that was the intended flow for the
application.quit, then why would it behave one way (immediately going to the
auto_close) when stepping through the code, yet continue through the message
boxes when actually running the code?

Regardless, adding the DoEvents command  after the application.quit makes the
code behave the way I expect it to, which is all I can ask of my computer!!

Thanks all for the input. I am a TM1 programmer (an OLAP tool - basically a
really big and robust pivot table) which uses Excel as its front end and it's
great finding a forum like this to discuss Excel / VBA issues. I hope I can
contribute sometime soon.

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on application.quit - code continues to run Or get search suggestion and latest updates.


Tagged: