Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to write a macro to modify an Excel chart | Charts and Charting in Excel | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
How to write a macro to get the system time in excel 97 | Excel Discussion (Misc queries) | |||
Looking for documentation/reference to write Excel Macro | Excel Programming | |||
How to write a macro to count clicks in Excel? | Excel Programming |