Hello Matt,
Not to my knowledge. Opening the file is what places it into Excel's
Workbook Collection. Until it is in the collection, VBA can't access
the object's properties. Add to that password protection is an internal
routine that isn't exposed outside of the Workbook. Maybe there is a way
using some other language or method, but with VBA the answer is no.
Sincerely,
Leith Ross
--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=480862