I'm trying to import a workbook into an open workbook using the code
below, however, the workbook I'm trying to import has a password. The
password is blank (essentially no password).

Sheets.Add Type:= "E:\mattw\My Documents\My Timesheets - 2006.xls"

So.... since it's "password protected" with a null password, how can I
unprotect the workbook BEFORE importing it?? Do I have to open it,
then remove the protection, or can I remove the protection while I'm
inserting it?

Thanks in advance!

Matt W


--
BVHis
------------------------------------------------------------------------
BVHis's Profile: http://www.excelforum.com/member.php...fo&userid=8593
View this thread: http://www.excelforum.com/showthread...hreadid=502238