Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's the situation - user has 15+ files that have unique passwords. They
also have one main file that they use to sum up the individual files. When they open the main file it asks for the password for every file used in the calc's. They want to avoid that. My thought was to set up code to open all the individual files, using the passwords, when the main file is opened. But my initial testing is showing that the main file wants to update the linked info (the calc's) before it runs the code in the Workbook_Open event. Is there a better way to do this? If not, can someone help me with the code. I have this in the Workbook_Open sub of the main file and it gives me an Object Required error: Private Sub Workbook_Open() Dim wbk As Workbook Set wbk = Workbook.Open(Filename:="M:\XLDATA\Herb\Testing\Te st1\test1.xls", password:="test1") End Sub Thanks!! Lauri |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need to remove passwords from a list of files. | Excel Programming | |||
suppressing passwords to edit linked files | Excel Programming | |||
updateLink; files with passwords , VBA help! | Excel Programming | |||
How to save Excel files which have passwords | Excel Programming | |||
How to save Excel files which have passwords | Excel Programming |