Out of Memory error with Application.Quit method
I ran into something similar with PowerPoint. It seems that when you're
running macros from AutoOpen, the poor app's not quite on its feet yet and
if the macro tells it to quit it totally loses it. Tech talk? <g>
I ended up writing a little VB app to start PPT, fire off the macro I wanted
to run, then force PPT to quit. Worked a treat.
--
Steve Rindsberg, PowerPoint MVP
Got a PowerPoint wish/suggestion/beef?
Get the PPT FAQs at http://www.rdpslides.com/pptfaq/
RnR PPTools - http://www.rdpslides.com/pptools/
------
Quote:
> I have an EXCEL VBA application that runs via auto_open. It calls (opens
> then runs a subroutine) another workbook and then tries to quit, via
> Application.Quit
> When I step through it it works fine
> When I run it (auto_open) normally I get a pop up
> Microsoft Visual Basic (in title bar, probably truncated)
> Out of Memory (in message area)
> when I click ok, I sometimes (not always) get a Dr Watson
> obviously, this is impairing automation!
> any ideas?
