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.
I've found that I could appear to do it using the 'shell' command to launch the app and then the 'SendKeys' command to simulate navigating the app to then be able to do a control C to copy..... but this looks very problematic as it could all go pear shaped if anything interupts the app (like a new email pop up message).

I've tried googling, but haven't come up with too much. Can anyone help.

Thanks.

 

[SkipVought]

Hi,

Could you be more specific about what you are trying to do?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}