| || |
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,