Jump to content
Sign in to follow this  
JoGa

Answer messagebox

Recommended Posts

JoGa

Greetings!

A VB-Script performs excel-automation by executing the excel-macro of a bunch of excel files.

Sometimes the macro causes an error and a messagebox from 'Visual Basic' and 'Windows Script Host' pops up.

Now I want automatically answer these messageboxes and let the app continue processing the next excel-file.

Any hints on how to archive the task of auto-answering a messagebox would be very much appreciated.

Thanks for reading

Jo

Share this post


Link to post
Share on other sites
JSThePatriot

How do you mean "archive" the task? Do you mean "automate"? I would recommend you check out the AdLibEnable() function, and see if that helps with what you're looking for.

Regards,

Jarvis


AutoIt Links

File-String Hash Plugin Updated! 04-02-2008 Plugins have been discontinued. I just found out.

ComputerGetInfo UDF's Updated! 11-23-2006

External Links

Vortex Revolutions Engineer / Inventor (Web, Desktop, and Mobile Applications, Hardware Gizmos, Consulting, and more)

Share this post


Link to post
Share on other sites
water

I assume Jo is a non native speaker - as I am. I think he means "achieve".

As the window is from another applikation I would write an AutoIT script that waits for the Window to appear, press the required key and then goes into a loop and waits for the next error window.

Edited by water

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
JSThePatriot

I assume Jo is a non native speaker - as I am. I think he means "achieve".

As the window is from another applikation I would write an AutoIT script that waits for the Window to appear, press the required key and then goes into a loop and waits for the next error window.

Ah water, thanks for the clarification, achieve would certainly fit what he was trying to relay. What you are saying would work as well. AdLibEnable() just allows you to do other things in your script while you're waiting for those items to pop up.

Thanks,

Jarvis


AutoIt Links

File-String Hash Plugin Updated! 04-02-2008 Plugins have been discontinued. I just found out.

ComputerGetInfo UDF's Updated! 11-23-2006

External Links

Vortex Revolutions Engineer / Inventor (Web, Desktop, and Mobile Applications, Hardware Gizmos, Consulting, and more)

Share this post


Link to post
Share on other sites
JoGa

I assume Jo is a non native speaker - as I am. I think he means "achieve".

[snip]

You are right! Thanks for your assistence.

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
Sign in to follow this  

×