R
RobVT
Using Access 2003.
I am trying to export my query results (which I have in Pivot Table
view) to an excel file graphing etc. purposes. I've tried using the
Pivot Chart options in Access but I don't get what I need.
I' know how to perform the process manually, but I would like to
automate the process with an "On Click" event.
Is there any way to do this with a macro or some VBA Code or am I just
wishful thinking?
Thanks in advance. All suggestioins are appreciated!
Rob
I am trying to export my query results (which I have in Pivot Table
view) to an excel file graphing etc. purposes. I've tried using the
Pivot Chart options in Access but I don't get what I need.
I' know how to perform the process manually, but I would like to
automate the process with an "On Click" event.
Is there any way to do this with a macro or some VBA Code or am I just
wishful thinking?
Thanks in advance. All suggestioins are appreciated!
Rob