Hi John,
Since You have macros in the workbook the security messagebox usually pop up when opening the workbook. We can send keystrokes to Excel to close it but that may or may not work .
The best approach is simple to use a classic ADO approach where we handle the workbook as a "database"...
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.