Controlling Hummingbird HostExplorer 7 through Excel

Hi all,

I'm doing an experimental project at work trying to do some screen scraping so we can create reports from Hummingbird HostExplorer 7. At the moment the main problem I'm having is ensuring the Hummingbird window is actually the active window.

As you'll be able to tell from the code below, this is still very much a work in progress. If anyone can advise a better option than emulating an Alt+Tab, it'd be much appreciated!

Please Login or Register  to view this content.

Kind regards as always,

Peter

uh, the whole point of the CS object is so you don't have to use Application.SendKeys at all.

Looking at the publically visible documentation they use "Host." where your code uses "CS.", and since you own the software you're likely to get better documentation on what the parameters are for the method calls n'such.

documentation found from google: http://mimage.hummingbird.com/alt_co...plications.pdf

also, formula for the TODAY() string your code mentions:

Please Login or Register  to view this content.