Extra basic opens & closes excel, but other .xls are unable to load

[Maltor]

I have a macro that starts in Attachmate Extra!, gets needed information, Opens excel, opens a file in excel then puts the information into a worksheet and prints. The macro then closes the workbook and quits excel. It then continues performing actions in Extra!

The Problem is after running the macro, every time I try to open an excel file with a macro, excel freezes.

Skeleton:

Set objSys = GetObject(Extra.System)
...
Set objExcel = CreateObject(Excel.Application)
Set objWork = objExcel.workbooks.Open("H:\file.xls&quot
...
Print ...
...
Call objWork.Close()
Call objExcel.Quit()
...
Main

 

[BrainB]

It may be that you do not clean up fully. Objects are retained in memory until cleared by code. So Quit the application then Set them all =Nothing in the reverse order that they were created.


Regards
BrianB
Use CupOfCoffee to speed up all windows applications
================================

 

[Maltor]

Sorry, I forgot to put that directly following objExcel.Quit()
is
Set objExcel = Nothing.

Thanks for the help though.
I don't set my Extra! object to nothing as I still want Extra! to be open after the macro runs.