PDA

View Full Version : Using remote desktop from VBA



someboddy
02-24-2011, 02:34 PM
I want to use VBA to automate some tasks on a Windows serve. That server is open to RDP and I usually access it via mstsc, so I tried to use a control I found in the additional controls list - "Microsoft RDP Client Control". However, I couldn't find out how to use it to enter my password(only the username) or how to do stuff on the server with that control(couldn't find it in Google either - only articles about how to set up the connection and stuff), which leads me into thinking that this control is meant to be used by the front end user, not by the program that hosts it.

So, I need another solution. The action I need to do on that server are to launch a program with command line parameters, to get a list of all files in a folder including creation dates and preferably sizes, and to move files to my own system. A COM object that allows me to send command line commands and receive the response as a string would be perfect, but I can manage with anything else that has those features.

So, is it even possible?