yushi Posted October 27, 2009 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 !
BugFix Posted October 27, 2009 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
yushi Posted October 27, 2009 Author 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.
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