VBA to automatically export query to folder every day

[laurenh345]

Hi everyone!

I am new to VBA and I was wondering if there was a VBA that could export a set query everyday to an external folder. This is because I run reports everyday based on the export I get from excel. I would be so grateful for any guidance or help with this. Thanks in advance!

Access database name: AllScripts PM1
Query name: RVU Report
External folder name: P:\WRVU

 

[Joe4]

Take a look at some of the options mentioned here.

Automating Queries In An Access 2010 Database

I have 6 queries in a db that I'm running each night, saving & publishing the file for use elsewhere. Does anyone know where I can get some direction on setting up to automate this?

stackoverflow.com

I have used the last option myself.

 

[laurenh345]

That was very helpful, I was able to base it off of that. Thank you so muhc!

 

[Joe4]

You are welcome!
Glad it worked out for you.