I am not sure that what I want to do can be done, but I am sure someone on
the forum can let me know.

Members of our buying group use remote desktop to connect to the groups
accounting system to enter new orders on their own accounts. For security the
only option on the desktop is the order entry screen in Sage MMS. If you need
to print the order locally you have to copy the active window to the
clipboard, switch to the local machine and paste it into Excel or Word. Is it
possible in VBA to switch from the local desktop to an open Remote desktop,
copy the active window and paste it into Excel/Word automatically?



Thanks in advance


--
Tony Green

see if this helps

http://support.microsoft.com/kb/312135

--


Gary


"ADG" wrote in message
...
I am not sure that what I want to do can be done, but I am sure someone on
the forum can let me know.

Members of our buying group use remote desktop to connect to the groups
accounting system to enter new orders on their own accounts. For security the
only option on the desktop is the order entry screen in Sage MMS. If you need
to print the order locally you have to copy the active window to the
clipboard, switch to the local machine and paste it into Excel or Word. Is it
possible in VBA to switch from the local desktop to an open Remote desktop,
copy the active window and paste it into Excel/Word automatically?



Thanks in advance


--
Tony Green

Thanks for the post, unfortunately this did not help. I effectively need to
print the open window to my local printer. There are no print options in the
software, and no printers to select. The only option that I have is to copy
the screen to the clipboard, and paste it into a local app to get my print,
--
Tony Green


"Gary Keramidas" wrote:

see if this helps

http://support.microsoft.com/kb/312135

--


Gary


"ADG" wrote in message
...
I am not sure that what I want to do can be done, but I am sure someone on
the forum can let me know.

Members of our buying group use remote desktop to connect to the groups
accounting system to enter new orders on their own accounts. For security the
only option on the desktop is the order entry screen in Sage MMS. If you need
to print the order locally you have to copy the active window to the
clipboard, switch to the local machine and paste it into Excel or Word. Is it
possible in VBA to switch from the local desktop to an open Remote desktop,
copy the active window and paste it into Excel/Word automatically?



Thanks in advance


--
Tony Green