View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jackie Jackie is offline
external usenet poster
 
Posts: 78
Default How to write a macro in Excel which can .....?

Hi,

Does anyone know how to write a macro in an Excel file which can copy and
append the data in an Excel worksheet to an existing Access file? Also at the
same time, a graph in that Excel worksheet is linked to a PowerPoint file. So
when the macro is run, I hope both the Access and PowerPoint files will be
updated automatically.

Since I am doing some works which require data analyisis by using Excel, I
currently need to copy and append the data to the Access database manually.
Also I copy the graph from the Excel file to the PowerPoint file manually as
well. It would be great and save a lot of time if one macro in Excel can
manipulate between Excel, Access and PowerPoint?

Thanks and regards,
Jackie