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.
|