View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default VBA Crashing XL on reload

Check the task manager and see if Excel is already running. I don't believe
GetObject will discover this situation if Excel is "hung up" because you
code has failed to release a reference to it.

--
Regards,
Tom Ogilvy

"Andrew Marshall" wrote in
message ...
I have an outlook macro, automating XL. Pseudo code follows

begin
If XL running
use existing instance
else
create new instance

open workbook( filename )
make changes to workbook
end

The crash occurs if I reload the workbook I opened. I cannot close the
workbook programmatically since the point of the macro is to allow the

user
to examine the changes. Has anyone seen anything like this before?

Many thanks,
Andrew.