Automation - which way round?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access table that is refreshed by a make table query activated from
a 'Confirm' button on a form. I have created an Excel PivotChart based on
the Access table and I want the Excel workbook that contains it to open after
the tabvel has been refreshed. However, I get an error indicating that the
database is still open.

Can I run the query and then open the Excel workbook from within Access?

Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Links to access databases 1
Link query to Excel and back to Access as table?? 1
Linked Excel File won't update 1
Access2000 automation problem 2
Make Table query. 2
Excel Protection 2
Turning a 3 column flat file into a "3D" Table 2
Linked Table and Read Only Issue 1

Back
Top