Mixing
Excel VBA macro fails when loaded from server, works when run from local disk?
I have written a macro in VBA. In short it runs on Auto_Open, displays a dialog box for user to enter some data, and when mandatory fields are filled, it populates a sheet in excel and saves as PDF or prints. Everything works perfectly, if the .xlsm file is opened from local disk (including opening from website, saving and then opening). However, if the .xlsm file is opened directly from a web server (intranet), everything works until the user tries to save as PDF or print. The error message is:
Run-time error '1004':
Application defined or object-defined error
and the offending line of code is:
Sheets("hakemus_laaja_FI (2)").Name = "hakemus"
(at the time of the error a sheet named "hakemus_laaja_FI (2)" exists on the workbook, whereas there is no sheet named "hakemus")
Furthermore, if the user doesn't have Office 365 but an older version of Excel, then even opening the .xlsm file directly from website works perfectly.
Any ideas what might be causing the error?
excel vba
asked Nov 20 '18 at 14:29
tj86430tj86430
114
add a comment |
I have written a macro in VBA. In short it runs on Auto_Open, displays a dialog box for user to enter some data, and when mandatory fields are filled, it populates a sheet in excel and saves as PDF or prints. Everything works perfectly, if the .xlsm file is opened from local disk (including opening from website, saving and then opening). However, if the .xlsm file is opened directly from a web server (intranet), everything works until the user tries to save as PDF or print. The error message is:
Run-time error '1004':
Application defined or object-defined error
and the offending line of code is:
Sheets("hakemus_laaja_FI (2)").Name = "hakemus"
(at the time of the error a sheet named "hakemus_laaja_FI (2)" exists on the workbook, whereas there is no sheet named "hakemus")
Furthermore, if the user doesn't have Office 365 but an older version of Excel, then even opening the .xlsm file directly from website works perfectly.
Any ideas what might be causing the error?
excel vba
asked Nov 20 '18 at 14:29
tj86430tj86430
114
5
Is it being opened in protected view?
– Nathan_Sav
Nov 20 '18 at 14:32
Please edit your original question and show the complete code of the procedure that runs when the file is opened, or at least a Minimal, Complete, and Verifiable example.
– Pᴇʜ
Nov 20 '18 at 14:34
It opens in protected view, after which the user clicks "enable editing". Then the user is asked whether to make it a trusted document and finally the user is asked to enable macros. All this is required to start the macro in the first place.
– tj86430
Nov 21 '18 at 6:45
I tried to make a minimal, complete and verifiable example. To do this, I moved the original .xlsm file to another site, and noticed that when loaded from there, the problem disappears. So far the problem is only reproducible when the .xlsm file is opened directly from the company intranet.
– tj86430
Nov 21 '18 at 6:47
add a comment |
I have written a macro in VBA. In short it runs on Auto_Open, displays a dialog box for user to enter some data, and when mandatory fields are filled, it populates a sheet in excel and saves as PDF or prints. Everything works perfectly, if the .xlsm file is opened from local disk (including opening from website, saving and then opening). However, if the .xlsm file is opened directly from a web server (intranet), everything works until the user tries to save as PDF or print. The error message is:
Run-time error '1004':
Application defined or object-defined error
and the offending line of code is:
Sheets("hakemus_laaja_FI (2)").Name = "hakemus"
(at the time of the error a sheet named "hakemus_laaja_FI (2)" exists on the workbook, whereas there is no sheet named "hakemus")
Furthermore, if the user doesn't have Office 365 but an older version of Excel, then even opening the .xlsm file directly from website works perfectly.
Any ideas what might be causing the error?
excel vba
asked Nov 20 '18 at 14:29
tj86430tj86430
114
I have written a macro in VBA. In short it runs on Auto_Open, displays a dialog box for user to enter some data, and when mandatory fields are filled, it populates a sheet in excel and saves as PDF or prints. Everything works perfectly, if the .xlsm file is opened from local disk (including opening from website, saving and then opening). However, if the .xlsm file is opened directly from a web server (intranet), everything works until the user tries to save as PDF or print. The error message is:
Run-time error '1004':
Application defined or object-defined error
and the offending line of code is:
Sheets("hakemus_laaja_FI (2)").Name = "hakemus"
(at the time of the error a sheet named "hakemus_laaja_FI (2)" exists on the workbook, whereas there is no sheet named "hakemus")
Furthermore, if the user doesn't have Office 365 but an older version of Excel, then even opening the .xlsm file directly from website works perfectly.
Any ideas what might be causing the error?
excel vba
excel vba
asked Nov 20 '18 at 14:29
tj86430tj86430
114
asked Nov 20 '18 at 14:29
tj86430tj86430
114
asked Nov 20 '18 at 14:29
tj86430tj86430
114
asked Nov 20 '18 at 14:29
tj86430tj86430
114
asked Nov 20 '18 at 14:29
tj86430tj86430
114
114
5
Is it being opened in protected view?
– Nathan_Sav
Nov 20 '18 at 14:32
Please edit your original question and show the complete code of the procedure that runs when the file is opened, or at least a Minimal, Complete, and Verifiable example.
– Pᴇʜ
Nov 20 '18 at 14:34
It opens in protected view, after which the user clicks "enable editing". Then the user is asked whether to make it a trusted document and finally the user is asked to enable macros. All this is required to start the macro in the first place.
– tj86430
Nov 21 '18 at 6:45
I tried to make a minimal, complete and verifiable example. To do this, I moved the original .xlsm file to another site, and noticed that when loaded from there, the problem disappears. So far the problem is only reproducible when the .xlsm file is opened directly from the company intranet.
– tj86430
Nov 21 '18 at 6:47
add a comment |
5
Is it being opened in protected view?
– Nathan_Sav
Nov 20 '18 at 14:32
Please edit your original question and show the complete code of the procedure that runs when the file is opened, or at least a Minimal, Complete, and Verifiable example.
– Pᴇʜ
Nov 20 '18 at 14:34
It opens in protected view, after which the user clicks "enable editing". Then the user is asked whether to make it a trusted document and finally the user is asked to enable macros. All this is required to start the macro in the first place.
– tj86430
Nov 21 '18 at 6:45
I tried to make a minimal, complete and verifiable example. To do this, I moved the original .xlsm file to another site, and noticed that when loaded from there, the problem disappears. So far the problem is only reproducible when the .xlsm file is opened directly from the company intranet.
– tj86430
Nov 21 '18 at 6:47
5
5
Is it being opened in protected view?
– Nathan_Sav
Nov 20 '18 at 14:32
Is it being opened in protected view?
– Nathan_Sav
Nov 20 '18 at 14:32
Please edit your original question and show the complete code of the procedure that runs when the file is opened, or at least a Minimal, Complete, and Verifiable example.
– Pᴇʜ
Nov 20 '18 at 14:34
Please edit your original question and show the complete code of the procedure that runs when the file is opened, or at least a Minimal, Complete, and Verifiable example.
– Pᴇʜ
Nov 20 '18 at 14:34
It opens in protected view, after which the user clicks "enable editing". Then the user is asked whether to make it a trusted document and finally the user is asked to enable macros. All this is required to start the macro in the first place.
– tj86430
Nov 21 '18 at 6:45
It opens in protected view, after which the user clicks "enable editing". Then the user is asked whether to make it a trusted document and finally the user is asked to enable macros. All this is required to start the macro in the first place.
– tj86430
Nov 21 '18 at 6:45
I tried to make a minimal, complete and verifiable example. To do this, I moved the original .xlsm file to another site, and noticed that when loaded from there, the problem disappears. So far the problem is only reproducible when the .xlsm file is opened directly from the company intranet.
– tj86430
Nov 21 '18 at 6:47
I tried to make a minimal, complete and verifiable example. To do this, I moved the original .xlsm file to another site, and noticed that when loaded from there, the problem disappears. So far the problem is only reproducible when the .xlsm file is opened directly from the company intranet.
– tj86430
Nov 21 '18 at 6:47
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%2f53395219%2fexcel-vba-macro-fails-when-loaded-from-server-works-when-run-from-local-disk%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%2f53395219%2fexcel-vba-macro-fails-when-loaded-from-server-works-when-run-from-local-disk%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
5
Is it being opened in protected view?
– Nathan_Sav
Nov 20 '18 at 14:32
Please edit your original question and show the complete code of the procedure that runs when the file is opened, or at least a Minimal, Complete, and Verifiable example.
– Pᴇʜ
Nov 20 '18 at 14:34
It opens in protected view, after which the user clicks "enable editing". Then the user is asked whether to make it a trusted document and finally the user is asked to enable macros. All this is required to start the macro in the first place.
– tj86430
Nov 21 '18 at 6:45
I tried to make a minimal, complete and verifiable example. To do this, I moved the original .xlsm file to another site, and noticed that when loaded from there, the problem disappears. So far the problem is only reproducible when the .xlsm file is opened directly from the company intranet.
– tj86430
Nov 21 '18 at 6:47