How to extract data using VBA from non-office apps

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

red6000 - 02 Oct 2005 17:39 GMT

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.

Reply to this Message

Helmut Weber - 03 Oct 2005 09:32 GMT

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.

Signature

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

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

Reply to this Message

Jezebel - 03 Oct 2005 09:37 GMT

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).

>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.

Reply to this Message