Jump to content
Sign in to follow this  

Grabbing text from VBA Dialogs in Excel

Recommended Posts



Although I have only been using for a few days, I must say what a wonderful and intuitive tool this is. I am trying to test a Excel Macro written in VBA and rather than manually test it am trying to automate the process. However, I have hit a problem that I can't seem to find an answer for. Please bear in mind I am fairly new to the area, and although I have searched the forum, maybe I am missing the wood for the trees, so to speak.

Basically, I am testing a dialog based application, written in VBA. During the automation, I want to grab text from a list view within one of the dialogs in order to set up some test cases, but nothing seems to work.

I am using the AU3Info tool, and that can't locate the text either. All this tool tells me is that the class is of type "F3 Server 60000000". I tried using this in various functions (i.e., ControlGetText) but nothing seems to work, and,

$hwnd = ControlGetHandle('[CLASS:F3 Server 60000000]', '', '0')

returns a blank string, i.e. fail.

Any help - much appreciated.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this