Pull data from multiple password protected workbooks

Caitlin535

New Member
Joined
Jan 8, 2016
Messages
18
Hello again -

I have several individual password protected workbooks - one for each employee, each with a unique password - that collect that employees timekeeping data. I'm trying to make a master sheet that will pull data from each of these individual files into one master file for me (the supervisor). However, every workbook to which I link then requires me to enter that workbook's password when I open the master sheet. I do know all of the passwords (I made these sheets), so I'm wondering if there's a way to automate entering all the passwords so that the data will get pulled in without me having to enter every password every time (which rather defeats the purpose.

I found the following thread, which seems to have something *close* to what I need:
http://www.mrexcel.com/forum/excel-questions/168849-linking-password-protected-workbook.html

Near the end "TLA" remarks about pulling data from multiple workbooks, each with a different password, but then he/she doesn't really explain how to actually do it - or at least, not in a manner I understand. Might someone be able to translate/clarify for me?

Thanks!!
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,096,203
Messages
5,448,932
Members
405,540
Latest member
midwife1087

This Week's Hot Topics

Top