View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew Marshall Andrew Marshall is offline
external usenet poster
 
Posts: 3
Default VBA Crashing XL on reload

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.