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  


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.