Styjun

The exact meaning of 'Mom made me a sandwich'

Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?

Legal workarounds for testamentary trust perceived as unfair

What does "Its cash flow is deeply negative" mean?

How to prove a simple equation?

Is it professional to write unrelated content in an almost-empty email?

If Nick Fury and Coulson already knew about aliens (Kree and Skrull) why did they wait until Thor's appearance to start making weapons?

Are police here, aren't itthey?

Is it convenient to ask the journal's editor for two additional days to complete a review?

I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin

How to avoid supervisors with prejudiced views?

Where do students learn to solve polynomial equations these days?

Is it possible to use a NPN BJT as switch, from single power source?

Does increasing your ability score affect your main stat?

Why does standard notation not preserve intervals (visually)

WOW air has ceased operation, can I get my tickets refunded?

Can you be charged for obstruction for refusing to answer questions?

Which one is the true statement?

Is there a way to save my career from absolute disaster?

Solving system of ODEs with extra parameter

Why is my new battery behaving weirdly?

Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?

Why the difference in type-inference over the as-pattern in two similar function definitions?

Some questions about different axiomatic systems for neighbourhoods

Is it possible to add a new workbook based on a locked template

1

I've got the following VBA code which Adds a new workbook based on a template.

Option Explicit

Public Sub AddTemplatedWB()
 Workbooks.Add ( _
 "C:VssBOXGeneric ProjectsPMC2template.xlsm" _
 )
End Sub

This works except when the template is locked. Then I get the usual password prompt:

Clicking Cancel gives me an error in VBA:

Is there any way to supply the password directly when adding the workbook? (This seems particularly weird since you can supply a password when Opening a file.)

If not, is there any other way to achieve what I'm looking for, i.e. creating a new file in memory based on a locked file?

excel vba

share|improve this question

edited Mar 20 at 10:01

Anton Lahti

asked Mar 20 at 9:36

Anton LahtiAnton Lahti

606

add a comment | 

1

I've got the following VBA code which Adds a new workbook based on a template.

Option Explicit

Public Sub AddTemplatedWB()
 Workbooks.Add ( _
 "C:VssBOXGeneric ProjectsPMC2template.xlsm" _
 )
End Sub

This works except when the template is locked. Then I get the usual password prompt:

Clicking Cancel gives me an error in VBA:

Is there any way to supply the password directly when adding the workbook? (This seems particularly weird since you can supply a password when Opening a file.)

If not, is there any other way to achieve what I'm looking for, i.e. creating a new file in memory based on a locked file?

excel vba

share|improve this question

edited Mar 20 at 10:01

Anton Lahti

asked Mar 20 at 9:36

Anton LahtiAnton Lahti

606

add a comment | 

I've got the following VBA code which Adds a new workbook based on a template.

Option Explicit

Public Sub AddTemplatedWB()
 Workbooks.Add ( _
 "C:VssBOXGeneric ProjectsPMC2template.xlsm" _
 )
End Sub

This works except when the template is locked. Then I get the usual password prompt:

Clicking Cancel gives me an error in VBA:

Is there any way to supply the password directly when adding the workbook? (This seems particularly weird since you can supply a password when Opening a file.)

If not, is there any other way to achieve what I'm looking for, i.e. creating a new file in memory based on a locked file?

excel vba

share|improve this question

edited Mar 20 at 10:01

Anton Lahti

asked Mar 20 at 9:36

Anton LahtiAnton Lahti

606

Option Explicit

Public Sub AddTemplatedWB()
 Workbooks.Add ( _
 "C:VssBOXGeneric ProjectsPMC2template.xlsm" _
 )
End Sub

share|improve this question

edited Mar 20 at 10:01

Anton Lahti

asked Mar 20 at 9:36

Anton LahtiAnton Lahti

606

share|improve this question

edited Mar 20 at 10:01

Anton Lahti

asked Mar 20 at 9:36

Anton LahtiAnton Lahti

606

asked Mar 20 at 9:36

Anton LahtiAnton Lahti

606

asked Mar 20 at 9:36

Anton LahtiAnton Lahti

606

2 Answers
2

active

oldest

votes

1

This code should work for you, since you can supply the password during the call:

Public Sub AddTemplatedWB()
 Workbooks.Open Filename:="C:VssBOXGeneric ProjectsPMC2template.xlsm", _
 Password:="YourPassword"
End Sub

---

Edit:

I was looking it up, but it seems that Microsoft didn't provide a direct way to do it. Maybe because they thought that it's not practical to lock a template with a password.

One possible solution that pops to my mind is to create a copy of the
template and then opening it.

share|improve this answer

edited Mar 21 at 18:02

answered Mar 20 at 10:02

LouisLouis

30329

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  No, this opens the template. I want a new workbook based on a template.
  
  – Anton Lahti
  Mar 20 at 10:08
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  I was looking it up, but it seems that Microsoft didn't provide a direct way to do it. Maybe because they thought that it's not practical to lock a template with a password. One possible solution that pops to my mind is to create a copy of the template and then opening it.
  
  – Louis
  Mar 20 at 10:53
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you accept my answer, since you used my solution to solve the issue? Thank you.
  
  – Louis
  Mar 21 at 18:04
  

  
  
  
  

add a comment | 

0

No, there doesn't seem to be any way to do this.

What I ended up doing instead is copying the template to a temporary file, Opening with the password.
Then I made sure that the temporary file was deleted after I was done with it.

share|improve this answer

answered Mar 21 at 8:59

Anton LahtiAnton Lahti

606

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
);



);

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55257597%2fis-it-possible-to-add-a-new-workbook-based-on-a-locked-template%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

This code should work for you, since you can supply the password during the call:

Public Sub AddTemplatedWB()
 Workbooks.Open Filename:="C:VssBOXGeneric ProjectsPMC2template.xlsm", _
 Password:="YourPassword"
End Sub

---

Edit:

I was looking it up, but it seems that Microsoft didn't provide a direct way to do it. Maybe because they thought that it's not practical to lock a template with a password.

One possible solution that pops to my mind is to create a copy of the
template and then opening it.

share|improve this answer

edited Mar 21 at 18:02

answered Mar 20 at 10:02

LouisLouis

30329

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  No, this opens the template. I want a new workbook based on a template.
  
  – Anton Lahti
  Mar 20 at 10:08
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  I was looking it up, but it seems that Microsoft didn't provide a direct way to do it. Maybe because they thought that it's not practical to lock a template with a password. One possible solution that pops to my mind is to create a copy of the template and then opening it.
  
  – Louis
  Mar 20 at 10:53
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you accept my answer, since you used my solution to solve the issue? Thank you.
  
  – Louis
  Mar 21 at 18:04
  

  
  
  
  

add a comment | 

1

This code should work for you, since you can supply the password during the call:

Public Sub AddTemplatedWB()
 Workbooks.Open Filename:="C:VssBOXGeneric ProjectsPMC2template.xlsm", _
 Password:="YourPassword"
End Sub

---

Edit:

I was looking it up, but it seems that Microsoft didn't provide a direct way to do it. Maybe because they thought that it's not practical to lock a template with a password.

One possible solution that pops to my mind is to create a copy of the
template and then opening it.

share|improve this answer

edited Mar 21 at 18:02

answered Mar 20 at 10:02

LouisLouis

30329

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  No, this opens the template. I want a new workbook based on a template.
  
  – Anton Lahti
  Mar 20 at 10:08
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  I was looking it up, but it seems that Microsoft didn't provide a direct way to do it. Maybe because they thought that it's not practical to lock a template with a password. One possible solution that pops to my mind is to create a copy of the template and then opening it.
  
  – Louis
  Mar 20 at 10:53
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you accept my answer, since you used my solution to solve the issue? Thank you.
  
  – Louis
  Mar 21 at 18:04
  

  
  
  
  

add a comment | 

This code should work for you, since you can supply the password during the call:

Public Sub AddTemplatedWB()
 Workbooks.Open Filename:="C:VssBOXGeneric ProjectsPMC2template.xlsm", _
 Password:="YourPassword"
End Sub

---

Edit:

I was looking it up, but it seems that Microsoft didn't provide a direct way to do it. Maybe because they thought that it's not practical to lock a template with a password.

One possible solution that pops to my mind is to create a copy of the
template and then opening it.

share|improve this answer

edited Mar 21 at 18:02

answered Mar 20 at 10:02

LouisLouis

30329

Public Sub AddTemplatedWB()
 Workbooks.Open Filename:="C:VssBOXGeneric ProjectsPMC2template.xlsm", _
 Password:="YourPassword"
End Sub

share|improve this answer

edited Mar 21 at 18:02

answered Mar 20 at 10:02

LouisLouis

30329

answered Mar 20 at 10:02

LouisLouis

30329

answered Mar 20 at 10:02

LouisLouis

30329

0

No, there doesn't seem to be any way to do this.

What I ended up doing instead is copying the template to a temporary file, Opening with the password.
Then I made sure that the temporary file was deleted after I was done with it.

share|improve this answer

answered Mar 21 at 8:59

Anton LahtiAnton Lahti

606

add a comment | 

0

No, there doesn't seem to be any way to do this.

What I ended up doing instead is copying the template to a temporary file, Opening with the password.
Then I made sure that the temporary file was deleted after I was done with it.

share|improve this answer

answered Mar 21 at 8:59

Anton LahtiAnton Lahti

606

add a comment | 

No, there doesn't seem to be any way to do this.

What I ended up doing instead is copying the template to a temporary file, Opening with the password.
Then I made sure that the temporary file was deleted after I was done with it.

share|improve this answer

answered Mar 21 at 8:59

Anton LahtiAnton Lahti

606

share|improve this answer

answered Mar 21 at 8:59

Anton LahtiAnton Lahti

606

answered Mar 21 at 8:59

Anton LahtiAnton Lahti

606

answered Mar 21 at 8:59

Anton LahtiAnton Lahti

606