ExcelBanter - Progam Pivot Table connection via OLE DB (vs ODBC)

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

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

- - Progam Pivot Table connection via OLE DB (vs ODBC) (https://www.excelbanter.com/excel-programming/417930-progam-pivot-table-connection-via-ole-db-vs-odbc.html)

Grd

Progam Pivot Table connection via OLE DB (vs ODBC)

Hi,

Is this possible to do through Pivot Table Wizard?
Is there VBA code to help me here?

Any help would be appreciated.

Tx

Suzanne

ShaneDevenshire

Progam Pivot Table connection via OLE DB (vs ODBC)

Hi,

In the first step of the Pivot Table Wizard choose External Data Source,
Next and follow the step of the wizard. You can record the whole process to
help you get started with the VBA stuff.

--
Thanks,
Shane Devenshire

"Grd" wrote:

Hi,

Is this possible to do through Pivot Table Wizard?
Is there VBA code to help me here?

Any help would be appreciated.

Tx

Suzanne

Grd

Progam Pivot Table connection via OLE DB (vs ODBC)

tx v much - I'll try that

"ShaneDevenshire" wrote:

Hi,

In the first step of the Pivot Table Wizard choose External Data Source,
Next and follow the step of the wizard. You can record the whole process to
help you get started with the VBA stuff.

--
Thanks,
Shane Devenshire

"Grd" wrote:

Hi,

Is this possible to do through Pivot Table Wizard?
Is there VBA code to help me here?

Any help would be appreciated.

Tx

Suzanne

All times are GMT +1. The time now is 10:03 PM.