MS Access macro that generates an Excel file from a template

[zzzjoshzzz]

Hi everyone, I don't yet have experience creating an automatic Excel sheet from an Excel template for a user that uses data from the database.

Essentially, I'm looking for a way to fill out the fields in the attached Excel sheet (and have the graph automatically change) and for the Excel sheet to pop up as a new file for the user (IE the template would stay untouched). You'll see in the Excel sheet that there are a number of cells that need to be filled from Access. I have a query in Access PER CELL that needs to be filled.

So, essentially I have 14 queries and I need the results of those queries to appear in the cells of a local version of an Excel template.

Thanks so much for your advice!

 

[spikepl]

SO what is unclear in the posts you searched and found about how to get data from Access to Excel?

 

[zzzjoshzzz]

I guess mostly that I have fourteen queries instead of one table

 

[Uncle Gizmo]

You may find this thread useful:- http://www.access-programmers.co.uk/forums/showthread.php?t=127596