You would test first if it's open.
I recently skimmed over threads that dealt with the ActiveX prompt but wasn't really interested since I wasn't looking for a solution to a problem not at hand. Perhaps it is possible to suppress it. The solution might have been an Options setting. If your wb is already open, I imagine that issue has been taken care of already, so an option might be to just use Access to open wb but not hidden, then deal with the prompt, then return to Access to continue the code. I think that would have to be a 2nd manual operation - maybe just as simple as clicking an Access message box "Click OK when ActiveX message has been deal with in Excel".
As for your last idea, the approach would still be the same: Automation, but this time from Excel.
HTH
EDIT - forgot to mention that Access wasn't hanging up, it was a prompt like the one you're describing, but for saving the wb. Couldn't see it bc wb was hidden. Or did I mention that?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
