I am in the process of converting a VB6 program to Dot.net 10.
I havre most of the code re-written, creating the excel book and sheets, loading it etc but am hitting a problem with a pivot table.
ptCache = ObjExcelB.PivotCaches.Add(XlPivotTableSourceType.xlExternal, arData)...