help VBA code in macro

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

I created 2 append queries to append data to a table called "Output" and
would like to help in creating a macro to first clear all the existing data
in "Output" table, then run the 2 queries. After data is appended to the
table, copy new data from Output table to either sheet1 of the "BSchedule"
Excel file or refresh the data by importing from the Excel file. Thanks
 
Cam said:
Hello,

I created 2 append queries to append data o a table called "Output" and
would like to help in creating a macro to first clear all the existing
data
in "Output" table, then run the 2 queries. After data is appended to the
table, copy new data from Output table to either sheet1 of the "BSchedule"
Excel file or refresh the data by importing from the Excel file. Thanks
Click to expand...
 

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

Help with VBA code in macro 6
Help VBA in macro 1
vba help with macro 1
Compact & Repair, Open table, close table, then run macro 3
Export table to txt file with a variable filename 0
How to Create a Macro to Import External Data 0
Append Queries in a Macro 6
TransferSpreadsheet macro, to Overwrite data not Append To Bottom 3

Back
Top