Jump to content
Sign in to follow this  
yushi

Excel userform control with AutoIt

Recommended Posts

yushi

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
BugFix

.. 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
yushi

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  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.