Workbooks.Open "C:\MyFolder\MyFiles.xls", password:="ABCD"

--
Regards,
Tom Ogilvy

"Nick S" wrote in
message ...

I want to open a number of other files that are password protected from
my main file. I know all the passwords and want to use code to
automatically open and close the files after getting data from each
file.

Any help greatly appreciated.

Nick


--
Nick S
------------------------------------------------------------------------
Nick S's Profile:
http://www.excelforum.com/member.php...o&userid=16512
View this thread: http://www.excelforum.com/showthread...hreadid=483480