Code to refresh Excel PivotChart and PowerPoint

M

Mike Collard

Hi

I have a PowerPoint chart that is linked to an Excel
spreadsheet that is in turn linked to an Access database.

I have an Access autoexec macro that updates the Access
tables but now I would like to add to the code so that it
automatically opens Excel and refreshes the data, saves
the Excel file and then opens PowerPoint and refreshes the
chart and saves that file.

Can anyone help please?

Thank you
 

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

Embed the same Excel multiple times 0
Email notifications without opening application 1
Cell data entering slow! 0
Powerpoint for mac 2008 with Sierra OS, Red X instead of graph in all powerpoint files 0
Mail Merge Directory Conditional Page Break 0
automatic copy paste excel chart 0
Linked Excel File won't update 1
copy paste excel charts into ppt automatically 0

Top