Hello Experts,
i am facing the issue with opening the workbooks via VBA.
i try to open workbook usual way "workbooks.Open filename", but macro stuck at this step due to waiting for user action as dialog box pop up in new opened workbook.
To be more specific, the new opened workbook loads a plenty of add-ins, and this dialog box is coming from them.
I tried application.displayalerts = false but it does not solve the issue.
Is there any way how to open workbook with disabling all add-ins, or suppressing all dialog boxes etc.? Or is possible to make actions on closed external workbook. In my case i need to perform "replace" function for all the sheets on external workbook.
Thank you
Jan
Bookmarks