connection of method PivotTableWizard() ?
When I use this parameter I get the error: The PivotTableWizard property of the Worksheet class can not be obtained. Here is the code:
Dim wb, excel As Object
wb = GetWorkbook(handle, workbook)
excel = wb.Application
Dim ws as Object = GetWorksheet(handle,workbook,worksheetname)
Dim objTable As PivotTable
objTable = ws.PivotTableWizard(,,,,,,,,,,,,,,,"ODBC;Provider=MSDASQL.1;Persist Security Info=False;Data Source=SQLexpress;Initial Catalog=PivotChart")