I'm trying to figure out how to programmatically export data from Access to Excel, create a chart in Excel and then copy that to Word. I've been performing this operation manually and It's no big deal, but the users want to be able to push a button. Here's the scenario:
At month end, five chart reports are generated from a large Access customer service database. Upper management wants to copy and paste these charts to their PDAs from Word. I haven't been able to copy Access charts to Excel or Word. So, I run the Access queries, copy the results table to Excel, generate an Excel chart and copy that chart to Word. I'm sure this process could be automated, but I haven't a clue where to start.
Any ideas? Anybody done anything like this before or seen it done?