Excel command line switches - positions
I notice that when I enter :
excel /r "c:temp1test001.xls"
I get read only. When I enter
excel "c:temp1test001.xls" /r
I do not get readonly.
When I enter
excel /s "c:temp1test001.xls"
I get safemode.
When I enter
excel "c:temp1test001.xls" /s
I still get safemode.
Is there any kind of logic to when switches go before or after?
Or is it a bit all over the place?
Thanks
microsoft-excel command-line command-line-arguments
asked Dec 10 at 16:10
Excelnoobster
61
add a comment |
I notice that when I enter :
excel /r "c:temp1test001.xls"
I get read only. When I enter
excel "c:temp1test001.xls" /r
I do not get readonly.
When I enter
excel /s "c:temp1test001.xls"
I get safemode.
When I enter
excel "c:temp1test001.xls" /s
I still get safemode.
Is there any kind of logic to when switches go before or after?
Or is it a bit all over the place?
Thanks
microsoft-excel command-line command-line-arguments
asked Dec 10 at 16:10
Excelnoobster
61
1
Safe mode is application-scope setting./skey means "... and run in safe mode ...". Read-only is workbook-scope setting./rkey means "... and open next files in read-only mode ...". If runningexcel 1.xls 2.xls /r 3.xls 4.xls1 and 2 are opened in RW, whereas 3 and 4 in RO mode.
– Akina
Dec 10 at 18:00
add a comment |
I notice that when I enter :
excel /r "c:temp1test001.xls"
I get read only. When I enter
excel "c:temp1test001.xls" /r
I do not get readonly.
When I enter
excel /s "c:temp1test001.xls"
I get safemode.
When I enter
excel "c:temp1test001.xls" /s
I still get safemode.
Is there any kind of logic to when switches go before or after?
Or is it a bit all over the place?
Thanks
microsoft-excel command-line command-line-arguments
asked Dec 10 at 16:10
Excelnoobster
61
I notice that when I enter :
excel /r "c:temp1test001.xls"
I get read only. When I enter
excel "c:temp1test001.xls" /r
I do not get readonly.
When I enter
excel /s "c:temp1test001.xls"
I get safemode.
When I enter
excel "c:temp1test001.xls" /s
I still get safemode.
Is there any kind of logic to when switches go before or after?
Or is it a bit all over the place?
Thanks
microsoft-excel command-line command-line-arguments
microsoft-excel command-line command-line-arguments
asked Dec 10 at 16:10
Excelnoobster
61
asked Dec 10 at 16:10
Excelnoobster
61
asked Dec 10 at 16:10
Excelnoobster
61
asked Dec 10 at 16:10
Excelnoobster
61
asked Dec 10 at 16:10
Excelnoobster
61
61
1
Safe mode is application-scope setting./skey means "... and run in safe mode ...". Read-only is workbook-scope setting./rkey means "... and open next files in read-only mode ...". If runningexcel 1.xls 2.xls /r 3.xls 4.xls1 and 2 are opened in RW, whereas 3 and 4 in RO mode.
– Akina
Dec 10 at 18:00
add a comment |
1
Safe mode is application-scope setting./skey means "... and run in safe mode ...". Read-only is workbook-scope setting./rkey means "... and open next files in read-only mode ...". If runningexcel 1.xls 2.xls /r 3.xls 4.xls1 and 2 are opened in RW, whereas 3 and 4 in RO mode.
– Akina
Dec 10 at 18:00
1
1
Safe mode is application-scope setting.
/s key means "... and run in safe mode ...". Read-only is workbook-scope setting. /r key means "... and open next files in read-only mode ...". If running excel 1.xls 2.xls /r 3.xls 4.xls 1 and 2 are opened in RW, whereas 3 and 4 in RO mode.– Akina
Dec 10 at 18:00
Safe mode is application-scope setting.
/s key means "... and run in safe mode ...". Read-only is workbook-scope setting. /r key means "... and open next files in read-only mode ...". If running excel 1.xls 2.xls /r 3.xls 4.xls 1 and 2 are opened in RW, whereas 3 and 4 in RO mode.– Akina
Dec 10 at 18:00
add a comment |
1 Answer
1
active
oldest
votes
As so kindly explained in Comments by Akina, the scope of the command-line switches of Excel can be either session-wide (affecting many things about how Excel works), or workbook-specific (just the specified files are affected).
When you choose Safe mode with /s, that setting alters the way that session of Excel works, for all workbooks, until you close Excel.
It ignores all files in the Application DataMicrosoftXlstart folder,
the default XLStart folder located in the directory where Excel or
Office is installed, and the alternate startup file location specified
on the General tab of the Excel Options dialog box. It also forces
Excel to ignore the toolbar file (Excel.xlb or .xlb). You
will see "Safe Mode" in the Excel title bar when you launch it with
the /s switch.
When you select Read-only, that applies only to the Excel files which follow the /r switch on that command line (the "workbook-scope" setting).
excel 1.xls 2.xls /r 3.xls 4.xls
opens 1.xls and 2.xls normally,
while 3.xls and 4.xls open read-only.
answered Dec 10 at 19:02
K7AAY
3,38321437
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1382361%2fexcel-command-line-switches-positions%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
As so kindly explained in Comments by Akina, the scope of the command-line switches of Excel can be either session-wide (affecting many things about how Excel works), or workbook-specific (just the specified files are affected).
When you choose Safe mode with /s, that setting alters the way that session of Excel works, for all workbooks, until you close Excel.
It ignores all files in the Application DataMicrosoftXlstart folder,
the default XLStart folder located in the directory where Excel or
Office is installed, and the alternate startup file location specified
on the General tab of the Excel Options dialog box. It also forces
Excel to ignore the toolbar file (Excel.xlb or .xlb). You
will see "Safe Mode" in the Excel title bar when you launch it with
the /s switch.
When you select Read-only, that applies only to the Excel files which follow the /r switch on that command line (the "workbook-scope" setting).
excel 1.xls 2.xls /r 3.xls 4.xls
opens 1.xls and 2.xls normally,
while 3.xls and 4.xls open read-only.
answered Dec 10 at 19:02
K7AAY
3,38321437
add a comment |
As so kindly explained in Comments by Akina, the scope of the command-line switches of Excel can be either session-wide (affecting many things about how Excel works), or workbook-specific (just the specified files are affected).
When you choose Safe mode with /s, that setting alters the way that session of Excel works, for all workbooks, until you close Excel.
It ignores all files in the Application DataMicrosoftXlstart folder,
the default XLStart folder located in the directory where Excel or
Office is installed, and the alternate startup file location specified
on the General tab of the Excel Options dialog box. It also forces
Excel to ignore the toolbar file (Excel.xlb or .xlb). You
will see "Safe Mode" in the Excel title bar when you launch it with
the /s switch.
When you select Read-only, that applies only to the Excel files which follow the /r switch on that command line (the "workbook-scope" setting).
excel 1.xls 2.xls /r 3.xls 4.xls
opens 1.xls and 2.xls normally,
while 3.xls and 4.xls open read-only.
answered Dec 10 at 19:02
K7AAY
3,38321437
add a comment |
As so kindly explained in Comments by Akina, the scope of the command-line switches of Excel can be either session-wide (affecting many things about how Excel works), or workbook-specific (just the specified files are affected).
When you choose Safe mode with /s, that setting alters the way that session of Excel works, for all workbooks, until you close Excel.
It ignores all files in the Application DataMicrosoftXlstart folder,
the default XLStart folder located in the directory where Excel or
Office is installed, and the alternate startup file location specified
on the General tab of the Excel Options dialog box. It also forces
Excel to ignore the toolbar file (Excel.xlb or .xlb). You
will see "Safe Mode" in the Excel title bar when you launch it with
the /s switch.
When you select Read-only, that applies only to the Excel files which follow the /r switch on that command line (the "workbook-scope" setting).
excel 1.xls 2.xls /r 3.xls 4.xls
opens 1.xls and 2.xls normally,
while 3.xls and 4.xls open read-only.
answered Dec 10 at 19:02
K7AAY
3,38321437
As so kindly explained in Comments by Akina, the scope of the command-line switches of Excel can be either session-wide (affecting many things about how Excel works), or workbook-specific (just the specified files are affected).
When you choose Safe mode with /s, that setting alters the way that session of Excel works, for all workbooks, until you close Excel.
It ignores all files in the Application DataMicrosoftXlstart folder,
the default XLStart folder located in the directory where Excel or
Office is installed, and the alternate startup file location specified
on the General tab of the Excel Options dialog box. It also forces
Excel to ignore the toolbar file (Excel.xlb or .xlb). You
will see "Safe Mode" in the Excel title bar when you launch it with
the /s switch.
When you select Read-only, that applies only to the Excel files which follow the /r switch on that command line (the "workbook-scope" setting).
excel 1.xls 2.xls /r 3.xls 4.xls
opens 1.xls and 2.xls normally,
while 3.xls and 4.xls open read-only.
answered Dec 10 at 19:02
K7AAY
3,38321437
answered Dec 10 at 19:02
K7AAY
3,38321437
answered Dec 10 at 19:02
K7AAY
3,38321437
answered Dec 10 at 19:02
K7AAY
3,38321437
3,38321437
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- 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.
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%2fsuperuser.com%2fquestions%2f1382361%2fexcel-command-line-switches-positions%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
Safe mode is application-scope setting.
/skey means "... and run in safe mode ...". Read-only is workbook-scope setting./rkey means "... and open next files in read-only mode ...". If runningexcel 1.xls 2.xls /r 3.xls 4.xls1 and 2 are opened in RW, whereas 3 and 4 in RO mode.– Akina
Dec 10 at 18:00