DaLiMan Posted November 29, 2016 Share Posted November 29, 2016 (edited) Hi, I need to open an Excel workbook so I thought I'd use Excel_Open and Excel_Bookopen like this. However, the workbook runs a vba code on startup which prompts the user. Now Excel_Bookopen just waits and waits.....Unitl the msgbox is clicked and the code is done. How can I have Excel_bookopen not wait, so I can do winwait for the msgbox action. Local $oExcel = _Excel_Open() Local $BulkMut = _Excel_BookOpen($oExcel, $BulkMut_path & $BulkMut_File) ;<-- don't want to wait here. Regards, Daniel Edited November 29, 2016 by DaLiMan Link to comment Share on other sites More sharing options...
water Posted November 29, 2016 Share Posted November 29, 2016 Coukld you please try this code snippet? Local $oExcel = _Excel_Open() $oExcel.EnableEvents = False Local $BulkMut = _Excel_BookOpen($oExcel, $BulkMut_path & $BulkMut_File) $oExcel.EnableEvents = True robertocm 1 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
DaLiMan Posted November 29, 2016 Author Share Posted November 29, 2016 4 hours ago, water said: Coukld you please try this code snippet? Local $oExcel = _Excel_Open() $oExcel.EnableEvents = False Local $BulkMut = _Excel_BookOpen($oExcel, $BulkMut_path & $BulkMut_File) $oExcel.EnableEvents = True Water, this is wonderfull. In others words: Your solution works... Thanx! Link to comment Share on other sites More sharing options...
water Posted November 29, 2016 Share Posted November 29, 2016 I'm glad you Like this solution My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now