| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ODBC Issue with Pivot Table | Excel Discussion (Misc queries) | |||
| Rrefesh pivot table without ODBC | Excel Programming | |||
| Pivot Table - ODBC Link to Access db | Excel Discussion (Misc queries) | |||
| ODBC errors with new pivot table | Excel Programming | |||
| Pivot Table Connection | Excel Programming | |||
Hybrid Mode
