DaLiMan

[SOLVED] Excel_Bookopen without wait?

4 posts in this topic

#1 ·  Posted (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 by DaLiMan

Share this post


Link to post
Share on other sites



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 (2016-08-18 - Version 1.4.6.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2016-12-04 - Version 1.2.2.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

 

Share this post


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

I'm glad you Like this solution :)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2016-08-18 - Version 1.4.6.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2016-12-04 - Version 1.2.2.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
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