How to access textboxes or their names in a GUI application from Excel VBA Macro RRS feed

  • Question

  • Hi All,

    My Scenario is I have an application installed on my machine, when I open it, it displays a 

    form which have several textboxes. I want to access those textboxes from my Excel VBA 

    program. Example: it has 4 textboxes and I want to highlight 3rd textbox and put some value 

    in that or get some value from that using a VBA Macro. Application installed is a GUI 

    application either built in .NET or JAVA. I know there is a tool called Macro Express using 

    which I can record a macro or I can record a Macro in excel itself but in my application 

    textbox count is variable and it changes as application works further. Is there any way that 

    I can get the textbox name or value in my VBA program either by referencing some dll or 

    another method. Pls help its urgent
    Saturday, June 14, 2014 12:57 PM