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