Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link password protected files to a master spreadsheet?
I have a "master" file that several workbooks are linked to. Each individual
workbook is password protected. I would like to be able to open and update the "master" file, however it is asking me for every individual password. This will not work. Is there a way to "override" or to give a "administrator" password so all the files update to the master without having to type in each password? Thank you. Laurie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link password protected files to a master spreadsheet?
How about just having another workbook that opens your workbook with the links
updated/not updated the way you want. Then the code continues to open the other workbooks. Saved from a previous post: Option Explicit Sub testme() Dim myFileNames As Variant Dim myPasswords As Variant Dim iCtr As Long Dim myRealWkbk As Workbook Dim myRealWkbkName As String Dim wkbk As Workbook myRealWkbkName = "C:\my documents\excel\book1.xls" myFileNames = Array("C:\my documents\excel\book11.xls", _ "C:\my documents\excel\book21.xls", _ "C:\my other folder\book11.xls") myPasswords = Array("pwd1", _ "pwd2", _ "pwd3") If UBound(myFileNames) < UBound(myPasswords) Then MsgBox "check names & passwords--qty mismatch!" Exit Sub End If Set myRealWkbk = Workbooks.Open(Filename:=myRealWkbkName, UpdateLinks:=0) For iCtr = LBound(myFileNames) To UBound(myFileNames) Set wkbk = Nothing On Error Resume Next Set wkbk = Workbooks.Open(Filename:=myFileNames(iCtr), _ Password:=myPasswords(iCtr)) On Error GoTo 0 If wkbk Is Nothing Then MsgBox "Check file: " & myFileNames(iCtr) Exit Sub End If wkbk.Close savechanges:=False Next iCtr End Sub (I got bored after 3 workbooks. You may want to test it with a couple to get it going.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Laurie M. wrote: I have a "master" file that several workbooks are linked to. Each individual workbook is password protected. I would like to be able to open and update the "master" file, however it is asking me for every individual password. This will not work. Is there a way to "override" or to give a "administrator" password so all the files update to the master without having to type in each password? Thank you. Laurie -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting image and document files into the spreadsheet | Excel Discussion (Misc queries) | |||
How do I link separate Excel files to one spreadsheet? | Excel Discussion (Misc queries) | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
Password protected files | Excel Discussion (Misc queries) |