Sign in to follow this  
Followers 0
yushi

Excel userform control with AutoIt

3 posts in this topic

Hye every one !

Using AutoIt, i'm trying to automate the execution of an Excel macro. I have an excel file that automatically launch an excel userform at start-up : i want to control this userform. My problem is that when I open the Excel file, the AutoIt script execution is paused until the userform is closed. How can I get the control of this userform ?

Have a nice day !

Share this post


Link to post
Share on other sites



.. i want to control this userform.

Why that? I think its better to interact with excel directly. AutoIt can do this for you. Have a look at Excel-UDF in the helpfile.

All, what happens in Excel with macros is an vba-script. It's no problem to convert this to AutoIt.


Best Regards BugFix  

Share this post


Link to post
Share on other sites

Why that? I think its better to interact with excel directly. AutoIt can do this for you. Have a look at Excel-UDF in the helpfile.

All, what happens in Excel with macros is an vba-script. It's no problem to convert this to AutoIt.

The excel file that i have to use (and control) is a tool that generates data. This tool have been created by another person and the VBA code is protected by a password. I have no other choice : i have to use the userform.

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  
Followers 0