Capturing Listboxes from External Applications

[learnerhere]

Hello,

I'm using office 2016.

I want excel or work to access a window in a (probably) .Net / Visual C++ program which contains a very large 6 column listbox.

This listbox is *very* slow to load, contains non confidential info ( company names / telephone numbers ) and has zero search function. The list is over 1200 rows long, and changes every month or so.

I have a javascript dynamic table I have written, and I want to extract the listbox data and put it into the javascript table for ease of access and autocomplete search.

I know from some VBA programing I did 15 years ago, this could be achieved using API calls. ( analysing the window element hierarchy ).

I was hoping for some pointers for 2018 - is there a better / simpler way to do this ?

Any help appreciated

[Kenneth Hobs]

Welcome to the forum!

An API method is probably the only way to do it. When I did it in the past, I used this one. http://patorjk.com/programming/tutorials/apispy.htm
It allows you to record vbscript code for some things.