Excel VBA - Forwarding data to external apps via. Con.ID

[b.tomlinson]

I am currently writing a VBA app in excel and a part of it's required functionality is to forward data to an external apps specific field. Currently it uses Appactivate + sendkeys to call up the app window and then tabs to the required field (the window itself consists of about 5 fields, then the usual ok / cancel / etc) and forward the text to the field.

Is there a combination of API calls or native vba call that would allow me to forward data directly to the field using the windows handled and ControlID of the field? It would reduce the chance of user generated error if i could force the information directly rather than relying on sending tabs via sendkeys.

I've looked everywhere but cant seem to find a way to impliment this! I don't know enough about the API etc at this stage to know the specific functions I am looking for.

Re,

B.T

 

[dk]

What is the external application? There may be an alternative to what you're thinking.

Dan

 

[b.tomlinson]

It's the process app. for a laser particle sizer. The app itself doesnt have any DDE support (bummer) or support for importing worklist data. The original idea was to use DDE or hack the actual softwares access database to force the information that we are forwarding to it into the system to get taken up. Unfortunately not viable options!

The actual software is the Mastersizer 2000 app.