how to create a VBA code to export pivot chart to word

  • Thread starter make a VBA to export pivot chart to word
  • Start date
M

make a VBA to export pivot chart to word

Hi there, i am trying to copy a pivot CHART from access into word and based
on previous posts i was led to this:
:Exporting an image of the view allows you to share a static image of the
view with other users.
Me.ChartSpace.ExportPicture "C:\yourdirectory\filename.gif", , 1024, 1024"

However i dont understand what to do with that...i have never written a code
before so i just need to know what to do like a step by step to write this
code so that when i click to pivot chart view in my forms i will be able to
export the PIVOT CHARTS to word. Thanks
 

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 use/create code in MS Word to calculate age? 0
Create a chart from a table in word thats dynamic 0
Ways to create a budget chart for money managment 1
VBA Export to PDF 0
How to create a bubble chart with more than 2 variables. 0
VBA concatenate ranges into a new document 0
Export the pivot chart view of a query to an image. 0
AutoCAD 3D to Microsoft Word 1

Top