Hi everyone,
I have 15 queries that I run every month that produce an output file that I use to update a database in Excel. Could someone provide me with info on how I could automate running these queries. I've read on a forum that there are two approaches that may be able to perform this, the first one includes .execute in the coding the other is .Doevents. Someone had mentioned that the .execute approach could be problematic in terms of timing because on large jobs it does not wait for the first query job to complete. Could someone please provide guidance on the best approach? I appreciate the help.