How to extract data using VBA from non-office apps

[red6000]

I know how to extract data using VBA from say 'excel'. but is it possible to
do it from non-MS Office apps.

If so, can anyone point me in thr right direction on how to do this.

Thanks.

 

[Helmut Weber]

Hi,

in the vba-editor goto "tools, references".
See if there is anything named like or similar to
the application you want to use. Add references
to the respective libraries. Goto the object browser.
Explore the newly added libraries.

Tough, though.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[Jezebel]

There's no generic answer to that. If the app provides a COM interface you
can work with it in the same way as Office apps (eg Corel, ACT!). If it
provides a data interface you may be able to use ADO or DAO (eg most
databases). If all else fails you might be able to use SendKeys (avoid this
like the plague, but sometimes it's the only option).