ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Have Excel send information to another program? (https://www.excelbanter.com/excel-programming/371837-have-excel-send-information-another-program.html)

[email protected]

Have Excel send information to another program?
 
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

Have Excel send information to another program?
 
Various way; Automation, DDE, SendMessage, SendKeys.
What is the target app.

NickHK

wrote in message
ups.com...
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?




Don Wiss

Have Excel send information to another program?
 
On 30 Aug 2006 17:55:55 -0700, wrote:

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

[email protected]

Have Excel send information to another program?
 
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 wrote:
Various way; Automation, DDE, SendMessage, SendKeys.
What is the target app.

NickHK

wrote in message
ups.com...
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

Have Excel send information to another program?
 
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

wrote in message
oups.com...
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 wrote:
Various way; Automation, DDE, SendMessage, SendKeys.
What is the target app.

NickHK

wrote in message
ups.com...
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?






All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com