dush71816
06-14-2014, 05:45 AM
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
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