I'm using a set of macros that open the file using the code:

Workbooks.Open Filename:="[FileName.xls]"

And then copying over data from the file to the master workbook. When the
individual workbooks that I'm attempting to gather data from are password
protected, it forces whoever uses the master workbook to have all of the
passwords.

"Tim Williams" wrote:

Exactly how are you getting the data from the files ?

Tim

"Matt" wrote in message
...
I'm programming a tool for work that is comprised of several different
spreadsheets. There are about 15 individual spreadsheets on a networked
drive and a master spreadsheet that takes and compiles data from the other
15.

The issue I'm running into is that each of the 15 individual spreadsheets
is
password protected, so that only the owner of that spreadsheet can access
it.
I've created a macro on the master spreadsheet that will retreive the data
from each of the individual spreadsheets, but each time it attempts to
pull
data, it asks for the password.

Is there a way to bypass the password in Visual Basic so that the master
spreadsheet can compile the data from each of the individual spreadsheets
without it asking for a password? Any help or suggestions would be
appreciated.


.