Jump to content
DaLiMan

[SOLVED] Excel_Bookopen without wait?

Recommended Posts

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 by DaLiMan

Share this post


Link to post
Share on other sites
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

 


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites
water

I'm glad you Like this solution :)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×