WOW, thanks for all the good tips.
I am planning on working on the project this week. I did not even think of the windows scheduler method.
I think I will try that one first, and see how it works.
I am also glad to know about the OnTime syntax, we can use it as we develop more of this ODBC...
I have inherited several Excel Queries. They query a ODBC database and do a background query when Excel is opened.
I want to change this so that the queries can be run at night, or some other off time. The queies can result in 40-50 thousand records, and the folks that need to use them, don't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.