Using VBA can I access another computer's desktop that is on the same network as me?
0
I finished a program for one of my colleagues but the final section of the program needs to start an executable file which is on a different PC. In this case the PC being used is called SYS1-PC and it needs to tell EDITING-PC that it should double click an executable file on its desktop.
I thought it might be something like this:
RDPWindow = Shell("C:UsersFORMAT.PLIMDesktoptesting.exe /v:" & "[IP ADDRESS]", 1)
But I just get file not found. Now I am not sure does that mean it has found the computer or does that mean it looked for that on my own C drive?
Cheers for any help
vba command-prompt
edited Nov 20 at 10:14
Inarion
474211
asked Nov 20 at 9:50
Besarion
508
|
show 3 more comments
0
I finished a program for one of my colleagues but the final section of the program needs to start an executable file which is on a different PC. In this case the PC being used is called SYS1-PC and it needs to tell EDITING-PC that it should double click an executable file on its desktop.
I thought it might be something like this:
RDPWindow = Shell("C:UsersFORMAT.PLIMDesktoptesting.exe /v:" & "[IP ADDRESS]", 1)
But I just get file not found. Now I am not sure does that mean it has found the computer or does that mean it looked for that on my own C drive?
Cheers for any help
vba command-prompt
edited Nov 20 at 10:14
Inarion
474211
asked Nov 20 at 9:50
Besarion
508
You can't simply tell a remote PC to double-click something. You need to go through the correct interfaces to do that. It's not clear from your question what the current situation is when the error happens. Do you have a remote desktop connection established? Are you employing some other means to access the remote PC? Furthermore, the ms-access tag seems to not fit - there's nothing in your question that relates to MS Access.
– Inarion
Nov 20 at 10:06
The situation just stuck in the 1 computer for now. With no connection working. I was hoping to use RDP and then via cmd run the program. I added the Access tag because this runs out of an MS access database, wasnt sure if that was relevant.
– Besarion
Nov 20 at 10:08
It looked on your own C drive. I doubt can accomplish this due to network security. If possible, I expect have to be able to set up a drive mapping to the other PC folder or know the UNC path to the other PC.
– June7
Nov 20 at 10:12
So the quickest way to solve this would to simply run the starting program on the second computer so it runs the relevant executable as itself.
– Besarion
Nov 20 at 10:14
Yes, might be able to use TaskScheduler to run a script that opens the executable. I use VBScript to automate opening an Access file.
– June7
Nov 20 at 10:16
|
show 3 more comments
0
0
0
I finished a program for one of my colleagues but the final section of the program needs to start an executable file which is on a different PC. In this case the PC being used is called SYS1-PC and it needs to tell EDITING-PC that it should double click an executable file on its desktop.
I thought it might be something like this:
RDPWindow = Shell("C:UsersFORMAT.PLIMDesktoptesting.exe /v:" & "[IP ADDRESS]", 1)
But I just get file not found. Now I am not sure does that mean it has found the computer or does that mean it looked for that on my own C drive?
Cheers for any help
vba command-prompt
edited Nov 20 at 10:14
Inarion
474211
asked Nov 20 at 9:50
Besarion
508
I finished a program for one of my colleagues but the final section of the program needs to start an executable file which is on a different PC. In this case the PC being used is called SYS1-PC and it needs to tell EDITING-PC that it should double click an executable file on its desktop.
I thought it might be something like this:
RDPWindow = Shell("C:UsersFORMAT.PLIMDesktoptesting.exe /v:" & "[IP ADDRESS]", 1)
But I just get file not found. Now I am not sure does that mean it has found the computer or does that mean it looked for that on my own C drive?
Cheers for any help
vba command-prompt
vba command-prompt
edited Nov 20 at 10:14
Inarion
474211
asked Nov 20 at 9:50
Besarion
508
edited Nov 20 at 10:14
Inarion
474211
asked Nov 20 at 9:50
Besarion
508
edited Nov 20 at 10:14
Inarion
474211
edited Nov 20 at 10:14
Inarion
474211
edited Nov 20 at 10:14
Inarion
474211
474211
asked Nov 20 at 9:50
Besarion
508
asked Nov 20 at 9:50
Besarion
508
asked Nov 20 at 9:50
Besarion
508
508
You can't simply tell a remote PC to double-click something. You need to go through the correct interfaces to do that. It's not clear from your question what the current situation is when the error happens. Do you have a remote desktop connection established? Are you employing some other means to access the remote PC? Furthermore, the ms-access tag seems to not fit - there's nothing in your question that relates to MS Access.
– Inarion
Nov 20 at 10:06
The situation just stuck in the 1 computer for now. With no connection working. I was hoping to use RDP and then via cmd run the program. I added the Access tag because this runs out of an MS access database, wasnt sure if that was relevant.
– Besarion
Nov 20 at 10:08
It looked on your own C drive. I doubt can accomplish this due to network security. If possible, I expect have to be able to set up a drive mapping to the other PC folder or know the UNC path to the other PC.
– June7
Nov 20 at 10:12
So the quickest way to solve this would to simply run the starting program on the second computer so it runs the relevant executable as itself.
– Besarion
Nov 20 at 10:14
Yes, might be able to use TaskScheduler to run a script that opens the executable. I use VBScript to automate opening an Access file.
– June7
Nov 20 at 10:16
|
show 3 more comments
You can't simply tell a remote PC to double-click something. You need to go through the correct interfaces to do that. It's not clear from your question what the current situation is when the error happens. Do you have a remote desktop connection established? Are you employing some other means to access the remote PC? Furthermore, the ms-access tag seems to not fit - there's nothing in your question that relates to MS Access.
– Inarion
Nov 20 at 10:06
The situation just stuck in the 1 computer for now. With no connection working. I was hoping to use RDP and then via cmd run the program. I added the Access tag because this runs out of an MS access database, wasnt sure if that was relevant.
– Besarion
Nov 20 at 10:08
It looked on your own C drive. I doubt can accomplish this due to network security. If possible, I expect have to be able to set up a drive mapping to the other PC folder or know the UNC path to the other PC.
– June7
Nov 20 at 10:12
So the quickest way to solve this would to simply run the starting program on the second computer so it runs the relevant executable as itself.
– Besarion
Nov 20 at 10:14
Yes, might be able to use TaskScheduler to run a script that opens the executable. I use VBScript to automate opening an Access file.
– June7
Nov 20 at 10:16
You can't simply tell a remote PC to double-click something. You need to go through the correct interfaces to do that. It's not clear from your question what the current situation is when the error happens. Do you have a remote desktop connection established? Are you employing some other means to access the remote PC? Furthermore, the ms-access tag seems to not fit - there's nothing in your question that relates to MS Access.
– Inarion
Nov 20 at 10:06
You can't simply tell a remote PC to double-click something. You need to go through the correct interfaces to do that. It's not clear from your question what the current situation is when the error happens. Do you have a remote desktop connection established? Are you employing some other means to access the remote PC? Furthermore, the ms-access tag seems to not fit - there's nothing in your question that relates to MS Access.
– Inarion
Nov 20 at 10:06
The situation just stuck in the 1 computer for now. With no connection working. I was hoping to use RDP and then via cmd run the program. I added the Access tag because this runs out of an MS access database, wasnt sure if that was relevant.
– Besarion
Nov 20 at 10:08
The situation just stuck in the 1 computer for now. With no connection working. I was hoping to use RDP and then via cmd run the program. I added the Access tag because this runs out of an MS access database, wasnt sure if that was relevant.
– Besarion
Nov 20 at 10:08
It looked on your own C drive. I doubt can accomplish this due to network security. If possible, I expect have to be able to set up a drive mapping to the other PC folder or know the UNC path to the other PC.
– June7
Nov 20 at 10:12
It looked on your own C drive. I doubt can accomplish this due to network security. If possible, I expect have to be able to set up a drive mapping to the other PC folder or know the UNC path to the other PC.
– June7
Nov 20 at 10:12
So the quickest way to solve this would to simply run the starting program on the second computer so it runs the relevant executable as itself.
– Besarion
Nov 20 at 10:14
So the quickest way to solve this would to simply run the starting program on the second computer so it runs the relevant executable as itself.
– Besarion
Nov 20 at 10:14
Yes, might be able to use TaskScheduler to run a script that opens the executable. I use VBScript to automate opening an Access file.
– June7
Nov 20 at 10:16
Yes, might be able to use TaskScheduler to run a script that opens the executable. I use VBScript to automate opening an Access file.
– June7
Nov 20 at 10:16
|
show 3 more comments
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
});
}
});
draft saved
draft discarded
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%2f53390284%2fusing-vba-can-i-access-another-computers-desktop-that-is-on-the-same-network-as%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
draft saved
draft discarded
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%2f53390284%2fusing-vba-can-i-access-another-computers-desktop-that-is-on-the-same-network-as%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
You can't simply tell a remote PC to double-click something. You need to go through the correct interfaces to do that. It's not clear from your question what the current situation is when the error happens. Do you have a remote desktop connection established? Are you employing some other means to access the remote PC? Furthermore, the ms-access tag seems to not fit - there's nothing in your question that relates to MS Access.
– Inarion
Nov 20 at 10:06
The situation just stuck in the 1 computer for now. With no connection working. I was hoping to use RDP and then via cmd run the program. I added the Access tag because this runs out of an MS access database, wasnt sure if that was relevant.
– Besarion
Nov 20 at 10:08
It looked on your own C drive. I doubt can accomplish this due to network security. If possible, I expect have to be able to set up a drive mapping to the other PC folder or know the UNC path to the other PC.
– June7
Nov 20 at 10:12
So the quickest way to solve this would to simply run the starting program on the second computer so it runs the relevant executable as itself.
– Besarion
Nov 20 at 10:14
Yes, might be able to use TaskScheduler to run a script that opens the executable. I use VBScript to automate opening an Access file.
– June7
Nov 20 at 10:16