ExcelBanter - OLE automation with PivotTable and external Data Source

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - OLE automation with PivotTable and external Data Source (https://www.excelbanter.com/excel-programming/365731-ole-automation-pivottable-external-data-source.html)

Kam

OLE automation with PivotTable and external Data Source

I would like to VFP to create an excel workbook, with multiple worksheets.
Creating PivotTable using the data in SQL server and SQL Analysis Services.

Is there any documents and samples in this area?

All times are GMT +1. The time now is 04:40 PM.