ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I get Office to activate a command in a non Office program (https://www.excelbanter.com/excel-discussion-misc-queries/122854-how-can-i-get-office-activate-command-non-office-program.html)

Terry T.

How can I get Office to activate a command in a non Office program
 
I'd like to use Excel or another Office program to activate an import link in
a cash register program called "Registerlink" by Royal Business Machines. I
can leave the computer on and both programs open but would like to
synchronize data in the middle of the night when the computer and register
are unattended. So far, someone has to physically click the "Synchronize"
button on the "Registerlink" program.

[email protected]

How can I get Office to activate a command in a non Office program
 
Hi Terry,

The only way I can think of doing this is by using the SendKeys
function in a scheduled macro. But this requires that this
"Registerlink" functionality can be called by a keyboard shortcut (such
as ALT + <Character). It would also be a possible solution if the
"Registerlink" button has the focus per default, ie if you hit Enter in
this program it is this button that gets pressed.

Regards,
Steve
www.stkomp.com

Terry T. wrote:
I'd like to use Excel or another Office program to activate an import link in
a cash register program called "Registerlink" by Royal Business Machines. I
can leave the computer on and both programs open but would like to
synchronize data in the middle of the night when the computer and register
are unattended. So far, someone has to physically click the "Synchronize"
button on the "Registerlink" program.




All times are GMT +1. The time now is 12:37 PM.

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