Code to refresh Excel PivotChart and PowerPoint

  • Thread starter Thread starter Mike Collard
  • Start date Start date
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
 
Back
Top