Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crash reload close | Excel Discussion (Misc queries) | |||
Reload Excel | Excel Discussion (Misc queries) | |||
How to reload Excel-- no longer have the cd program? | Excel Discussion (Misc queries) | |||
How do I force a reload of the workbook? | New Users to Excel | |||
my system crashed & i had to reload xp, now I cant get my office . | Setting up and Configuration of Excel |