Program PivotTable Form (Excel embedded in Unbound ObjectFrame)

G

Gcook888

I might try to program w/VBA the PivotTable that is created with the Form
PivotTable Wizard.

Its an Excel workbook embedded in an Unbound ObjectFrame. In my ObjectBrowser
I can find no symbols corresponding to the PivotTable even after setting a
reference to Excel. The ObjectFrame is listed as a member of the form.

Is it possible (thru automation or something) to get a hold of the Excel
PivotTable with Access VBA?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get OWC PivotTable data into an Excel Application 1
Using Certain Forms From The Pivottable Wizard in Excel VBA 0
How to create portable Excel applications? 2
PivotTables' name? And the PivotChart 1
How to Pause an Excel VBA script without freezing excel 1
Manipulating Embedded Excel Spdsht / Chart / Macro from Word 2007 0
Corrupt files due to pivot remnants after saving via VBA 0
PivotTable bug with custom groups ? 0

Top