| || |
How Automate Excel forms or Excel GUI ?
I need to automate a excel based application. This application use many user forms like Dialogs, combobox, buttons etc. I tried using Macro Recording, but Excel is only recording the cells, not the GUI actions. For example, let on cell D6 there is any combo box. I selected any comobobox item. In recorded macro, it is only saying range.select("D6"), no recording about selected combobox item.
Please help by providing your suggestions to automate it. Any other ideas apart from Excel macro recording are also welcome.
Regards & Thanks,
I believe recent versions of AutoIt support Excel.. See for instance Excel Example Scripts - Example Scripts - AutoIt Forums
AutoIt can be downloaded from here: AutoItScript - AutoItScript Website
There are a number of proficient AutoIt users on this board as well. I myself haven't used it.
Each object will have a name. Combobox1, Checkbox2, etc. You can code directly into these objects (Sub ComboBox1_Change()) or you can pick up or change the values in macros by using the properties of the object (If ComboBox1.Text = "test" then Checkbox2.Value = "False")