EXECUTING 3RD PARTY APPLICATION

[Byte_Me]

I wish to execute a 3rd party application from VBA, passing the necessary
data required (userid, password, menu prompts), then capture whatever data
required and passing it back to VBA.

 

[David H]

You'll need to contact the third party developer to see if they've built in
the capability to automate their software using VBA. If they have, they
should be able to provide you with the necessary support.

 

[Jack Leach]

As david mentions this is a very application-specific process. There are
almost as many ways to deal with this as there is different applications, and
each is going to be different.

The XML language seems to be the best way to get complex data back and forth
between programs, and is used extensively. Most applications that support
coding will have some sort of functionality for XML, so you may want to read
up on it some and see what's available for you with your TPA. Nice thing is
XML isn't super-complicated and once you work with it you can use that just
about anywhere.

hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)