yushi Posted October 27, 2009 Share Posted October 27, 2009 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 ! Link to comment Share on other sites More sharing options...
BugFix Posted October 27, 2009 Share Posted October 27, 2009 .. 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 Link to comment Share on other sites More sharing options...
yushi Posted October 27, 2009 Author Share Posted October 27, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now