Import and Run macro

A

Adam

I need to create a macro that will import an Excel file to a table with no modifications needed. It then has to delete a current table 'A' and rename the imported table to table 'A'. After that it need to run 3 queries in succession, Q1, Q2, Q3. I know how to have the macro run the 3 queries in succession, but I do not know how to do the rest

Please help
Thanks!!
 
K

Ken Snell

Here are the action steps (in order) that you'll need to run. I've not
filled in the arguments for each, but I think you'll find that they're
self-explanatory when you create the macro in design view window:


TransferSpreadsheet

DeleteObject

Rename

OpenQuery

OpenQuery

OpenQuery


--
Ken Snell
<MS ACCESS MVP>

Adam said:
I need to create a macro that will import an Excel file to a table with no
Click to expand...
modifications needed. It then has to delete a current table 'A' and rename
the imported table to table 'A'. After that it need to run 3 queries in
succession, Q1, Q2, Q3. I know how to have the macro run the 3 queries in
succession, but I do not know how to do the rest.
 

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

Setting column width in a table with a macro is not working 0
Macro Loop 0
Need Help with Macro Security 1
Macro to copy table of contents to a new doc 0
Menu Macro Not Executing - Need Help 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Adding sequence numbers to paragraphs 0

Top