Office Automation - Charting - Access to Excel

[John de Beer]

I using Office Automation to do the following.

I run a query in Access using a multi-select list box as the basis for
changing my query string. I export the query to a spreadsheet through
a transferspreadsheet method, and then reopen that spreadsheet to make
a update a chart and export that chart to a gif. I use the
activeworksheets.autorunmacros feature to update the charts and export
the gif. I am using the listbox control to allow someone to do for 1
to X charts at a time.

My question is the following;

Is it faster to write the charting feature and the export to gif
function from Access code or the way I am doing now which is

- export the data through the transferspreadsheet method
then reopen the spreadsheet and run an Auto_open macro to update the
chart and expot the gif.

Thanks

jdb


Cross posted to
microsoft.public.office.developer.automation,
microsoft.public.access.modulesdaovba