EXECUTING 3RD PARTY APPLICATION

  • Thread starter Thread starter Byte_Me
  • Start date Start date
B

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

News Smartphone apps record your screen and send it to 3rd parties 1
How to Transfer Emails from One Gmail Account to Another? Simple Steps 2
How can I run FTP using VBA in Access 2007 3
Backup 3rd party database 5
Connection String - SQL Server Express 5
Password complexity rules with a custom logon form 5
VBA Password 1
Pass-through Query from VBA Module in MS Access 2

Back
Top