Excel Hangs - Ideas?

[RoguePoet01]

Hi,

I've got a program that runs in the background and writes two XL spreadsheets then e-mails them to people.

The problem is that after the program runs, it hangs up XL so that when one of the e-mailed Excel files is opened from Outlook, you can't see the file.

I've made sure to close the application and "Set XLApp = Nothing", but it still keeps getting hung up.

Any ideas?

 

[ToshTrent]

is there anyway to clear the memory from our apps?

 

[vladk]

ToshTrent,

Yes. Handling the errors appropriately should do the job. Assuming that normal termination deletes the objects, closes files, and so on.

Vladk

 

[AGIMA]

You could kill the process if you know which one it is...



AGIMA - professional web hosting is our business.

AGIMA Computing

http://www.agima.com.au

 

[RoguePoet01]

vladk,

"Handling the errors appropriately should do the job."

That's a good point. I was trapping errors in my VB program, but this particular error or "anamoly" was on the Excel side, and no error code was generated.

Sub ProcessXL()

On Error Goto ErrorExecute

....

Exit Sub
ErrorExecute:
If cn.State = adStateOpen Then ErrCase = 3
Call ErrorLog
Response = MsgBox("Error in the 'ProcessXL' subroutine.", vbCritical, "Error&quot
End
End Sub

 

[vladk]

RoguePoet01,

I am not sure of how you handled the errors in VBA inside Excel.
That handling should in theory report the problems in Excel and at least alert about the possible implications.

Vladk