VBA Application.Workbooks.Open(file_name.xls) opens already opened workbook instead of file_name passed
I am trying to open a workbook using Application.Workbooks.Open by passing the file name along with path as an argument.
If any other excel is opened it is activating opened excel instead of opening excel with the given file name
My Code :
Dim rsWB As Workbook
Dim fname As String
fname = "C:Userstestmy developmentouputnew_output.xlsx"
Set rsWB = Application.Workbooks.Open(fname)
rsWB.Activate
MsgBox (rsWB.Name)
Case 1. If no other excel file is open. rsWB.Name = new_output.xlsx
Case 2. If output.xlsx is already open. rsWB.Name = output.xlsx
excel vba excel-vba
asked Nov 14 '18 at 7:25
user3243344user3243344
243
add a comment |
I am trying to open a workbook using Application.Workbooks.Open by passing the file name along with path as an argument.
If any other excel is opened it is activating opened excel instead of opening excel with the given file name
My Code :
Dim rsWB As Workbook
Dim fname As String
fname = "C:Userstestmy developmentouputnew_output.xlsx"
Set rsWB = Application.Workbooks.Open(fname)
rsWB.Activate
MsgBox (rsWB.Name)
Case 1. If no other excel file is open. rsWB.Name = new_output.xlsx
Case 2. If output.xlsx is already open. rsWB.Name = output.xlsx
excel vba excel-vba
asked Nov 14 '18 at 7:25
user3243344user3243344
243
1
Is this literally your code, or is this extracted from a larger set? I've never seen the workbook returned from Open() be anything other than the filename passed in.
– Tim Williams
Nov 14 '18 at 8:00
Yes. It was part of the existing code block, but I had pasted the exact lines causing the problem. I am not sure what is causing it.
– user3243344
Nov 14 '18 at 8:51
This is a known bug. You must first test whether or not your workbook is already open in Excel.
– jkpieterse
Nov 14 '18 at 9:29
add a comment |
I am trying to open a workbook using Application.Workbooks.Open by passing the file name along with path as an argument.
If any other excel is opened it is activating opened excel instead of opening excel with the given file name
My Code :
Dim rsWB As Workbook
Dim fname As String
fname = "C:Userstestmy developmentouputnew_output.xlsx"
Set rsWB = Application.Workbooks.Open(fname)
rsWB.Activate
MsgBox (rsWB.Name)
Case 1. If no other excel file is open. rsWB.Name = new_output.xlsx
Case 2. If output.xlsx is already open. rsWB.Name = output.xlsx
excel vba excel-vba
asked Nov 14 '18 at 7:25
user3243344user3243344
243
I am trying to open a workbook using Application.Workbooks.Open by passing the file name along with path as an argument.
If any other excel is opened it is activating opened excel instead of opening excel with the given file name
My Code :
Dim rsWB As Workbook
Dim fname As String
fname = "C:Userstestmy developmentouputnew_output.xlsx"
Set rsWB = Application.Workbooks.Open(fname)
rsWB.Activate
MsgBox (rsWB.Name)
Case 1. If no other excel file is open. rsWB.Name = new_output.xlsx
Case 2. If output.xlsx is already open. rsWB.Name = output.xlsx
excel vba excel-vba
excel vba excel-vba
asked Nov 14 '18 at 7:25
user3243344user3243344
243
asked Nov 14 '18 at 7:25
user3243344user3243344
243
asked Nov 14 '18 at 7:25
user3243344user3243344
243
asked Nov 14 '18 at 7:25
user3243344user3243344
243
asked Nov 14 '18 at 7:25
user3243344user3243344
243
243
1
Is this literally your code, or is this extracted from a larger set? I've never seen the workbook returned from Open() be anything other than the filename passed in.
– Tim Williams
Nov 14 '18 at 8:00
Yes. It was part of the existing code block, but I had pasted the exact lines causing the problem. I am not sure what is causing it.
– user3243344
Nov 14 '18 at 8:51
This is a known bug. You must first test whether or not your workbook is already open in Excel.
– jkpieterse
Nov 14 '18 at 9:29
add a comment |
1
Is this literally your code, or is this extracted from a larger set? I've never seen the workbook returned from Open() be anything other than the filename passed in.
– Tim Williams
Nov 14 '18 at 8:00
Yes. It was part of the existing code block, but I had pasted the exact lines causing the problem. I am not sure what is causing it.
– user3243344
Nov 14 '18 at 8:51
This is a known bug. You must first test whether or not your workbook is already open in Excel.
– jkpieterse
Nov 14 '18 at 9:29
1
1
Is this literally your code, or is this extracted from a larger set? I've never seen the workbook returned from Open() be anything other than the filename passed in.
– Tim Williams
Nov 14 '18 at 8:00
Is this literally your code, or is this extracted from a larger set? I've never seen the workbook returned from Open() be anything other than the filename passed in.
– Tim Williams
Nov 14 '18 at 8:00
Yes. It was part of the existing code block, but I had pasted the exact lines causing the problem. I am not sure what is causing it.
– user3243344
Nov 14 '18 at 8:51
Yes. It was part of the existing code block, but I had pasted the exact lines causing the problem. I am not sure what is causing it.
– user3243344
Nov 14 '18 at 8:51
This is a known bug. You must first test whether or not your workbook is already open in Excel.
– jkpieterse
Nov 14 '18 at 9:29
This is a known bug. You must first test whether or not your workbook is already open in Excel.
– jkpieterse
Nov 14 '18 at 9:29
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%2f53295019%2fvba-application-workbooks-openfile-name-xls-opens-already-opened-workbook-inst%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%2f53295019%2fvba-application-workbooks-openfile-name-xls-opens-already-opened-workbook-inst%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
1
Is this literally your code, or is this extracted from a larger set? I've never seen the workbook returned from Open() be anything other than the filename passed in.
– Tim Williams
Nov 14 '18 at 8:00
Yes. It was part of the existing code block, but I had pasted the exact lines causing the problem. I am not sure what is causing it.
– user3243344
Nov 14 '18 at 8:51
This is a known bug. You must first test whether or not your workbook is already open in Excel.
– jkpieterse
Nov 14 '18 at 9:29