[SOLVED] Excel_Bookopen without wait?

[DaLiMan]

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

[water]

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

 

[DaLiMan]

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!

[water]

I'm glad you Like this solution