Mixing
VBA Open batch file - window closes immediately after executing
I am trying to automate the execution of a batch file using VBA. I tried using the code below to execute. When I run this it opens a cmd window and then immediately closes. Any suggestions?
Sub openbatchfile()
path = "C:HedgeRxConnectCTAUpload.bat"
Call shell(path, vbNormalNoFocus)
End Sub
When I run it manually below is what appears on the cmd window. It opens up a proxy server authentication which requests my log in credentials. Is there anyway to automate my login details for this?
C:HedgeRxConnect>C:
C:HedgeRxConnect>HRxCImport.exe JobConfig_FixedWidthCTAImport_CTA.xml
excel vba batch-file
edited Jan 1 at 23:41
Matteo NNZ
6,31343253
asked Jan 1 at 22:56
Erik GutierrezErik Gutierrez
1
add a comment |
I am trying to automate the execution of a batch file using VBA. I tried using the code below to execute. When I run this it opens a cmd window and then immediately closes. Any suggestions?
Sub openbatchfile()
path = "C:HedgeRxConnectCTAUpload.bat"
Call shell(path, vbNormalNoFocus)
End Sub
When I run it manually below is what appears on the cmd window. It opens up a proxy server authentication which requests my log in credentials. Is there anyway to automate my login details for this?
C:HedgeRxConnect>C:
C:HedgeRxConnect>HRxCImport.exe JobConfig_FixedWidthCTAImport_CTA.xml
excel vba batch-file
edited Jan 1 at 23:41
Matteo NNZ
6,31343253
asked Jan 1 at 22:56
Erik GutierrezErik Gutierrez
1
Welcome to SO. Does "When I run it manually" means running bat file in cmd window or by double clicking in window? May refer the link
– Ahmed AU
Jan 2 at 2:09
Hi there, yes i am referring to double clicking on it.
– Erik Gutierrez
Jan 3 at 14:25
add a comment |
I am trying to automate the execution of a batch file using VBA. I tried using the code below to execute. When I run this it opens a cmd window and then immediately closes. Any suggestions?
Sub openbatchfile()
path = "C:HedgeRxConnectCTAUpload.bat"
Call shell(path, vbNormalNoFocus)
End Sub
When I run it manually below is what appears on the cmd window. It opens up a proxy server authentication which requests my log in credentials. Is there anyway to automate my login details for this?
C:HedgeRxConnect>C:
C:HedgeRxConnect>HRxCImport.exe JobConfig_FixedWidthCTAImport_CTA.xml
excel vba batch-file
edited Jan 1 at 23:41
Matteo NNZ
6,31343253
asked Jan 1 at 22:56
Erik GutierrezErik Gutierrez
1
I am trying to automate the execution of a batch file using VBA. I tried using the code below to execute. When I run this it opens a cmd window and then immediately closes. Any suggestions?
Sub openbatchfile()
path = "C:HedgeRxConnectCTAUpload.bat"
Call shell(path, vbNormalNoFocus)
End Sub
When I run it manually below is what appears on the cmd window. It opens up a proxy server authentication which requests my log in credentials. Is there anyway to automate my login details for this?
C:HedgeRxConnect>C:
C:HedgeRxConnect>HRxCImport.exe JobConfig_FixedWidthCTAImport_CTA.xml
excel vba batch-file
excel vba batch-file
edited Jan 1 at 23:41
Matteo NNZ
6,31343253
asked Jan 1 at 22:56
Erik GutierrezErik Gutierrez
1
edited Jan 1 at 23:41
Matteo NNZ
6,31343253
asked Jan 1 at 22:56
Erik GutierrezErik Gutierrez
1
edited Jan 1 at 23:41
Matteo NNZ
6,31343253
edited Jan 1 at 23:41
Matteo NNZ
6,31343253
edited Jan 1 at 23:41
Matteo NNZ
6,31343253
6,31343253
asked Jan 1 at 22:56
Erik GutierrezErik Gutierrez
1
asked Jan 1 at 22:56
Erik GutierrezErik Gutierrez
1
asked Jan 1 at 22:56
Erik GutierrezErik Gutierrez
1
1
Welcome to SO. Does "When I run it manually" means running bat file in cmd window or by double clicking in window? May refer the link
– Ahmed AU
Jan 2 at 2:09
Hi there, yes i am referring to double clicking on it.
– Erik Gutierrez
Jan 3 at 14:25
add a comment |
Welcome to SO. Does "When I run it manually" means running bat file in cmd window or by double clicking in window? May refer the link
– Ahmed AU
Jan 2 at 2:09
Hi there, yes i am referring to double clicking on it.
– Erik Gutierrez
Jan 3 at 14:25
Welcome to SO. Does "When I run it manually" means running bat file in cmd window or by double clicking in window? May refer the link
– Ahmed AU
Jan 2 at 2:09
Welcome to SO. Does "When I run it manually" means running bat file in cmd window or by double clicking in window? May refer the link
– Ahmed AU
Jan 2 at 2:09
Hi there, yes i am referring to double clicking on it.
– Erik Gutierrez
Jan 3 at 14:25
Hi there, yes i am referring to double clicking on it.
– Erik Gutierrez
Jan 3 at 14:25
add a comment |
1 Answer
1
active
oldest
votes
Automate? What is the frequency of batch file executions? If you need to run whenever windows starts, you can use regedit in the Run key to automatically run batch. If the frequency is hourly you can use the windows task scheduler.
answered Jan 1 at 23:06
BonemanBoneman
82
add a comment |
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%2f53999577%2fvba-open-batch-file-window-closes-immediately-after-executing%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Automate? What is the frequency of batch file executions? If you need to run whenever windows starts, you can use regedit in the Run key to automatically run batch. If the frequency is hourly you can use the windows task scheduler.
answered Jan 1 at 23:06
BonemanBoneman
82
add a comment |
Automate? What is the frequency of batch file executions? If you need to run whenever windows starts, you can use regedit in the Run key to automatically run batch. If the frequency is hourly you can use the windows task scheduler.
answered Jan 1 at 23:06
BonemanBoneman
82
add a comment |
Automate? What is the frequency of batch file executions? If you need to run whenever windows starts, you can use regedit in the Run key to automatically run batch. If the frequency is hourly you can use the windows task scheduler.
answered Jan 1 at 23:06
BonemanBoneman
82
Automate? What is the frequency of batch file executions? If you need to run whenever windows starts, you can use regedit in the Run key to automatically run batch. If the frequency is hourly you can use the windows task scheduler.
answered Jan 1 at 23:06
BonemanBoneman
82
edited Jan 1 at 23:19
answered Jan 1 at 23:06
BonemanBoneman
82
answered Jan 1 at 23:06
BonemanBoneman
82
answered Jan 1 at 23:06
BonemanBoneman
82
82
add a comment |
add a comment |
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%2f53999577%2fvba-open-batch-file-window-closes-immediately-after-executing%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
Welcome to SO. Does "When I run it manually" means running bat file in cmd window or by double clicking in window? May refer the link
– Ahmed AU
Jan 2 at 2:09
Hi there, yes i am referring to double clicking on it.
– Erik Gutierrez
Jan 3 at 14:25