Run EXE from RDP Window (RDP Window is linked to Weblink)

Multi tool use
A Weblink login has list of IPs connecting to remote desktop
I am able to click particular ip using “ie.document”
But that links open another window of Remote Desktop (Which is Server) of that IP
Directly I am not able to take remote connection due to security reason.
There is one EXE in C drive of Server PC(Remote Desktop Pc).
How can I run that EXE , Login and extract required File using VBA?
I have done few coding till IP List
I have tried APPACTIVATE , Not able to Run that EXE, Please Suggest
USR = Workbooks(MP).Worksheets("Sheet1").Range("C2").Value
PWD = Workbooks(MP).Worksheets("Sheet1").Range("C3").Value
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.navigate "http://web.xyz.com/frmLoginACMO.aspx"
While ie.readyState <> 4: DoEvents: Wend
ie.Visible = True
ie.Document.getElementByID("ctl00_MainContent_txtusername").Value = (USR)
ie.Document.getElementByID("ctl00_MainContent_txtpassword").Value = (PWD)
ie.Document.getElementByID("ctl00_MainContent_imgbtnLogin").Click
AppActivate "10.24.187.203@op_BoUSer-WindowsRDP"
excel vba visual-studio excel-vba
add a comment |
A Weblink login has list of IPs connecting to remote desktop
I am able to click particular ip using “ie.document”
But that links open another window of Remote Desktop (Which is Server) of that IP
Directly I am not able to take remote connection due to security reason.
There is one EXE in C drive of Server PC(Remote Desktop Pc).
How can I run that EXE , Login and extract required File using VBA?
I have done few coding till IP List
I have tried APPACTIVATE , Not able to Run that EXE, Please Suggest
USR = Workbooks(MP).Worksheets("Sheet1").Range("C2").Value
PWD = Workbooks(MP).Worksheets("Sheet1").Range("C3").Value
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.navigate "http://web.xyz.com/frmLoginACMO.aspx"
While ie.readyState <> 4: DoEvents: Wend
ie.Visible = True
ie.Document.getElementByID("ctl00_MainContent_txtusername").Value = (USR)
ie.Document.getElementByID("ctl00_MainContent_txtpassword").Value = (PWD)
ie.Document.getElementByID("ctl00_MainContent_imgbtnLogin").Click
AppActivate "10.24.187.203@op_BoUSer-WindowsRDP"
excel vba visual-studio excel-vba
2
Please take time to feedback on prior answers given and accept answers that have worked. You have left a string of questions which have no accepts nor clarifications given when requested.
– QHarr
Dec 31 '18 at 12:22
1
Also, be very clear about whether a remote connection is required and is not permitted as that becomes an issue which way well involve your IT dept.
– QHarr
Dec 31 '18 at 12:36
add a comment |
A Weblink login has list of IPs connecting to remote desktop
I am able to click particular ip using “ie.document”
But that links open another window of Remote Desktop (Which is Server) of that IP
Directly I am not able to take remote connection due to security reason.
There is one EXE in C drive of Server PC(Remote Desktop Pc).
How can I run that EXE , Login and extract required File using VBA?
I have done few coding till IP List
I have tried APPACTIVATE , Not able to Run that EXE, Please Suggest
USR = Workbooks(MP).Worksheets("Sheet1").Range("C2").Value
PWD = Workbooks(MP).Worksheets("Sheet1").Range("C3").Value
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.navigate "http://web.xyz.com/frmLoginACMO.aspx"
While ie.readyState <> 4: DoEvents: Wend
ie.Visible = True
ie.Document.getElementByID("ctl00_MainContent_txtusername").Value = (USR)
ie.Document.getElementByID("ctl00_MainContent_txtpassword").Value = (PWD)
ie.Document.getElementByID("ctl00_MainContent_imgbtnLogin").Click
AppActivate "10.24.187.203@op_BoUSer-WindowsRDP"
excel vba visual-studio excel-vba
A Weblink login has list of IPs connecting to remote desktop
I am able to click particular ip using “ie.document”
But that links open another window of Remote Desktop (Which is Server) of that IP
Directly I am not able to take remote connection due to security reason.
There is one EXE in C drive of Server PC(Remote Desktop Pc).
How can I run that EXE , Login and extract required File using VBA?
I have done few coding till IP List
I have tried APPACTIVATE , Not able to Run that EXE, Please Suggest
USR = Workbooks(MP).Worksheets("Sheet1").Range("C2").Value
PWD = Workbooks(MP).Worksheets("Sheet1").Range("C3").Value
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.navigate "http://web.xyz.com/frmLoginACMO.aspx"
While ie.readyState <> 4: DoEvents: Wend
ie.Visible = True
ie.Document.getElementByID("ctl00_MainContent_txtusername").Value = (USR)
ie.Document.getElementByID("ctl00_MainContent_txtpassword").Value = (PWD)
ie.Document.getElementByID("ctl00_MainContent_imgbtnLogin").Click
AppActivate "10.24.187.203@op_BoUSer-WindowsRDP"
excel vba visual-studio excel-vba
excel vba visual-studio excel-vba
edited Jan 7 at 8:55
Pᴇʜ
22.2k42750
22.2k42750
asked Dec 31 '18 at 12:07
AshishAshish
274
274
2
Please take time to feedback on prior answers given and accept answers that have worked. You have left a string of questions which have no accepts nor clarifications given when requested.
– QHarr
Dec 31 '18 at 12:22
1
Also, be very clear about whether a remote connection is required and is not permitted as that becomes an issue which way well involve your IT dept.
– QHarr
Dec 31 '18 at 12:36
add a comment |
2
Please take time to feedback on prior answers given and accept answers that have worked. You have left a string of questions which have no accepts nor clarifications given when requested.
– QHarr
Dec 31 '18 at 12:22
1
Also, be very clear about whether a remote connection is required and is not permitted as that becomes an issue which way well involve your IT dept.
– QHarr
Dec 31 '18 at 12:36
2
2
Please take time to feedback on prior answers given and accept answers that have worked. You have left a string of questions which have no accepts nor clarifications given when requested.
– QHarr
Dec 31 '18 at 12:22
Please take time to feedback on prior answers given and accept answers that have worked. You have left a string of questions which have no accepts nor clarifications given when requested.
– QHarr
Dec 31 '18 at 12:22
1
1
Also, be very clear about whether a remote connection is required and is not permitted as that becomes an issue which way well involve your IT dept.
– QHarr
Dec 31 '18 at 12:36
Also, be very clear about whether a remote connection is required and is not permitted as that becomes an issue which way well involve your IT dept.
– QHarr
Dec 31 '18 at 12:36
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53987334%2frun-exe-from-rdp-window-rdp-window-is-linked-to-weblink%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53987334%2frun-exe-from-rdp-window-rdp-window-is-linked-to-weblink%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
qL rfd9qdkPgaMQ1LA6Or
2
Please take time to feedback on prior answers given and accept answers that have worked. You have left a string of questions which have no accepts nor clarifications given when requested.
– QHarr
Dec 31 '18 at 12:22
1
Also, be very clear about whether a remote connection is required and is not permitted as that becomes an issue which way well involve your IT dept.
– QHarr
Dec 31 '18 at 12:36