Hi

I have a workbook that is initially opened by the user with a modifying
password. Then when a macro is run I want to be able to close and then
re-open this workbook without having to input the password again.

I have tried:

Workbooks.Open Filename:="D:name.xls", Password:="My_Password"

but I am still asked to enter the password.

How do I do this?

Paul


--
PaulC
------------------------------------------------------------------------
PaulC's Profile: http://www.excelforum.com/member.php...fo&userid=7563
View this thread: http://www.excelforum.com/showthread...hreadid=274042