Create an automated macro in Access which runs a query once a week

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

Guest

Looking to create an automated process in Access which runs a query and
exports it to Excel
 
See VBA Editor Help on TransferSpreadsheet. You can identify a select query
in place of a table as the source of the transfer.
 
Does your organization use Outlook? In Outlook, it is possible to
program code that fires on the REMINDER event for an AppointmentItem or
TaskItem. Also, because of the integration between the Office family of
products, there's pretty much nothing that can't be programed using
Outlook VBA.
 

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

How To Run Sub In Exported From Access To Excel Table? 0
Automating Excel to run an auto open macro in the sheet. 4
Automating a rename of a table? 3
Help with vba autorunning macro? 2
Running a query automatically/automating query and exporting proce 4
Error Exporting Access Query Results to Excel 1
Access Access macro build gone wrong 0
Automate export from Excel to Access 1

Back
Top