Have Excel send information to another program?

[Shaka215]

I was woundering if it was possiable to have Excel click somewhere
inside of another program and enter the contents of cell A3 into a
specific feild inside of that program??? I can do this with a 3rd party
macro recording tool but thats to dependent on that type of
program...any ideas?

 

[NickHK]

Various way; Automation, DDE, SendMessage, SendKeys.
What is the target app.

NickHK

 

[Don Wiss]

I was woundering if it was possiable to have Excel click somewhere
inside of another program and enter the contents of cell A3 into a
specific feild inside of that program??? I can do this with a 3rd party
macro recording tool but thats to dependent on that type of
program...any ideas?

I've done it. I used APL+Win with an ActiveX link. But I seriously doubt
you had this software in mind. Just what program would you like to see
communicate with Excel?

Don <www.donwiss.com> (e-mail link at home page bottom).

 

[Shaka215]

Well any program for that matter...the target program would be SAP or
Prophet21. Any ideas of how to develop methods to get this to work
correctly?

 

[NickHK]

You would need to check their documentation to see which of the first 2
methods (if any) they support.
If not, then the second 2 methods will be necessary.

NickHK