I am building a workbook to automate reporrt generation for data in Access. I
have 40+ locations that I have to generate reports for, so I am creating
worksheets for each site, and quereying Access for the specific data.

What I would like to do, is on the worksheet for each site, have the data
that I need for that site and the specific charts that I need to generate.

I am using ListObjects.Add to add a QueryTable object to the worksheet. It
query's the access db and gets the data that I need. This part works fine. It
gets the data, and creates an xl table on the sheet.

My question, is how do I make changes to that query. Let's say that the user
wants to change the dates for the data being charted. How do I change that
query and bring the new data back into the existing xl table (so that the
chart updates itself)?

I haven't been able to figure out how to do that. I need to make sure that I
can change the query, re-run it and put the data into the previously defined
xl table. From what I can tell, the QueryTable object will not put the data
into a previously defined table.

Any guidance or pointers are greatly appreciated.

Steve