[AccessD] Excel Graphs from Access Data - Ideas, Please

Hi Drew,
Yes, maybe - if I do it that way, let me think how I'd go about it. 

I would create my Access queries with their date-range, wells, or 
wellfield parameters to get my data - create my Excel spreadsheets and 
graphs for the several different data combinations.  Then import into 
Excel from the updated Access queries as desired.  Yes?  The queries are 
all parameter queries, getting their parameters from combo boxes and 
calendar controls on a form - so, I'm thinking to use make-table queries 
to provide standard consistent data sources for the Excel spreadsheets.

Most of the users in this client office do know something about Excel, 
but virtually nothing about Access.  For that reason I am looking for 
ways to provide them with buttons and drop-down selection lists to 
generate the data set they want to see graphed, then a quick easy leap 
of some kind to the Excel spreadsheets and graphs of the selected data.  
On the Excel side I would like to provide a button to run the macro that 
generates the graph, or have the data come directly into named ranges 
that are already set up as the source for my graph.  I don't yet see how 
to import fresh data from the Access query-made-table into Excel without 
overwriting any named ranges I had established - and, thereby, losing 
the sources for my graph series.

I like the simplicity of your suggestion.  Would you share more of your 
thoughts, please?

Thank you,
Tina


DWUTKA at marlow.com wrote:
> Why automate at all?  Excel allows you to place external data on a
> spreadsheet, and you can have the sheet prompt to 'refresh' the data
> whenever excel is opened.  It's pretty straight forward, and wouldn't
> require using any code.  (Hey, wait, am I advocating a non-code approach?
> William may take away my 'Code Boy' title!)
>
> Drew
>
>
>