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

How to write a macro in Excel which can .....?
 

To append records to an Access database you need to be fairly confident in
writing VBA code and in referencing ADODB Recordsets. If you are Ok with that
do a little searching on the web and that should get you started. This forum
will be able to help you if you get stuck. As for updating the powerpoint I
am afraid you are on your own there. I am sure it is do-able but I couldn't
tell you how.

HTH

"Jackie" wrote:

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