Hi

I need to open a whole series of workbooks. What i would like to be able to
do is if the workbook has a Password (as in File Save As (selecting the
Tools Option then Password to Open)), close the workbook immediatley.

How do I do this?

D

You could look at the .haspassword property for that workbook.

But I guess my question is how did you open it if it had a password?



David McNaughton wrote:

Hi

I need to open a whole series of workbooks. What i would like to be able to
do is if the workbook has a Password (as in File Save As (selecting the
Tools Option then Password to Open)), close the workbook immediatley.

How do I do this?

D

--

Dave Peterson