M
Mark Burns
OK, since intellisense gives up after hitting "me.pivottable." in a code
window...
Can anybody tell me WHAT Object Type is returned there?
I know it is an (?abstracted/dumbed-down?) interface,
since under the hood it is late-bound (the Object Browser returns
Access.Form.PivotTable as type: Object) and eventually will either be an
OWC10.PivotTable object or an OWC11.PivotTable Object, depending on what (if
any) office Web Components .DLL is in use, but WHAT Interface is it using?
(incidentally trying to assign me.PivotTable to, an owc11.PivotTable-typed
variable fails with a type error...?)
dim myPivotTable as owc11.PivotTable
set myPivotTable = me.PivotTable <--- *Thud* - Type Error ???
So what the heck does Me.PivotTable return, anyway??!! (It sorta Looks like
a PivotTable Object by browsing it in the Locals window...but apparently it's
not one?!)
HELP!
window...
Can anybody tell me WHAT Object Type is returned there?
I know it is an (?abstracted/dumbed-down?) interface,
since under the hood it is late-bound (the Object Browser returns
Access.Form.PivotTable as type: Object) and eventually will either be an
OWC10.PivotTable object or an OWC11.PivotTable Object, depending on what (if
any) office Web Components .DLL is in use, but WHAT Interface is it using?
(incidentally trying to assign me.PivotTable to, an owc11.PivotTable-typed
variable fails with a type error...?)
dim myPivotTable as owc11.PivotTable
set myPivotTable = me.PivotTable <--- *Thud* - Type Error ???
So what the heck does Me.PivotTable return, anyway??!! (It sorta Looks like
a PivotTable Object by browsing it in the Locals window...but apparently it's
not one?!)
HELP!