Error

[Gary]

Hi,

I have a VB 6.0 code that has been migrated to VB.NET.

This code basically writes data to an Excel file.

On execution of the migrated VB.NET code, I get an error:

----------------------------------------------------------------------------
---------------

An unhandled exception of type 'System.Runtime.InteropServices.COMException'
occurred in mscorlib.dll



Additional information: Exception from HRESULT: 0x800A03EC.

----------------------------------------------------------------------------
----------------



Please help !

- Gary

 

[Gary]

Here is the line of code that causes the error:

ExcelGlobal_definst.Selection.Subtotal(GroupBy:=3,
Function:=Excel.XlConsolidationFunction.xlSum, TotalList:=New Object() {8,
9, 10, 11, 13, 14, 16, 17, 19, 21, 22, 24, 25, 26, 27, 28},
Replace_Renamed:=True, PageBreaks:=False, SummaryBelowData:=False)

Please help !
- Gary -