1. I have complex program in the lab for talking to different instruments, Mobile phones etc. Somebody wrote a GUI with a couple of pull down menus so that a particular combination can be selected. I have different combinations in different cells of an excel file. I want to have a Macro so that when I click combination A, the macro will read the corresponding cells and send these values to the pull down menu of the GUI.
2. I think this can be done using the sendkeys from Excel. How to make sure that a particular value is send to send to a particular menu of GUI?. Can this be done using the "Cursor position" of the menu?. ..
3. Is there any other easier way to automate these...like windows script ???