I need to code an application through Microsoft's Office VBA, most likely through excel. The purpose of the code will be to loop through all current terminal/remote desktop sessions on a windows 2008 server, find a specific session, and then connect to it via Remote Control (therefore not only is it viewing the session but it can also interact with it). Essentially I need to mimic the manual process of opening up Task Manager (or TSADMIN), right clicking a session/user, and clicking remote control. The application will be run from one of these active sessions.
The reason I am using VBA via Office is because it is the only option I have at the moment. There is a library called 'Microsoft Terminal Services Control Type Library' which seems like the best bet, but I have absolutely no idea how to implement it. I can't find any specific examples for this particular library online (or at least my searches were empty). I really need help with either searching for solutions for my particular need, or coming up with any other alternative routes that are plausible with VBA.
The reason I am using VBA via Office is because it is the only option I have at the moment. There is a library called 'Microsoft Terminal Services Control Type Library' which seems like the best bet, but I have absolutely no idea how to implement it. I can't find any specific examples for this particular library online (or at least my searches were empty). I really need help with either searching for solutions for my particular need, or coming up with any other alternative routes that are plausible with VBA.
