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