xl97: Access violation closing Excel
Posted on 1998-06-16
I have a VB4 appl. that creates an excel spreadsheet and dumps data to it. (NT4) When I shut down Excel ('close the workbook), I get Dr. Watson:
Exception: access violation(0xc0000005),Address:0x3002db7
I'm using CreateObject to create my workbook and have tried
the combinations of setting the workbook/worksheet objects to nothing in my appl. to no avail.
dim xltemp, rptexcel as object
Set xltemp = CreateObject("Excel.sheet") 'Create OLE object
Set rptExcel = xltemp.ActiveSheet
'set xltemp = nothing
'set rptexcel = nothing
I've read the microsoft support doc. q176242, but am not
convinced that's whats happening here.
Any help you can give would be appreciated.