How do I reference the active chartspace of a pivotchart in VBA?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create several procedures in VBA to reformat (lines, series, and
labels) in a pivotchart and to then export the chart to a gif format from MS
Access.
The "me" operator does not seem to work for the chartspace object. My
question is then -- "How do I reference the current or active chartspace?"
 
I should clarify that I am working directly from queries to create the
pivotcharts and that I would like to have call my formating and exporting to
gif rountines from macros available on my pivotchart tool bar. Since the "Me"
operator only works for the forms collection, my question then is how do a
reference a specific chart/workspace from within a vba module in this
situation?
 
Back
Top