VBA - Check for password protection

I have written code to filesearch and then trawl the workbooks for any comments containing a particular string.

However when the code is running, if a sheet is password-protected it prompts.

Is there any way of checking to see if a file is PP'd without actually trying to open it and therefore getting prompted?

code is as below:

Set oBook = oExcel.Workbooks.Open(strWkShtPathAndNme, 0, True)

CIA,
Matt.

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

I went into vba propertiers and password protected. Still after f8 puts you
right back into the vba code. No request for password. Is ther something I am
missing?
Thanks

"Leith Ross" wrote:

>
> 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
>
>

Hi Curt,

After protecting the project, to activate the protection, save the workbook,
close and re-open Excel.


---
Regards,
Norman


"Curt" <[email protected]> wrote in message
news:[email protected]...
>I went into vba propertiers and password protected. Still after f8 puts you
> right back into the vba code. No request for password. Is ther something I
> am
> missing?
> Thanks
>
> "Leith Ross" wrote:
>
>>
>> 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
>>
>>

Hi Curt,

> close and re-open Excel.

Should have read:

close and re-open the workbook.


---
Regards,
Norman



"Norman Jones" <[email protected]> wrote in message
news:[email protected]...
> Hi Curt,
>
> After protecting the project, to activate the protection, save the
> workbook, close and re-open Excel.
>
>
> ---
> Regards,
> Norman
>
>
> "Curt" <[email protected]> wrote in message
> news:[email protected]...
>>I went into vba propertiers and password protected. Still after f8 puts
>>you
>> right back into the vba code. No request for password. Is ther something
>> I am
>> missing?
>> Thanks
>>
>> "Leith Ross" wrote:
>>
>>>
>>> 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
>>>
>>>
>
>

DUHHH why didn't I think of this. Found out after posting the question.
Thanks for the reply
Curt

"Norman Jones" wrote:

> Hi Curt,
>
> > close and re-open Excel.
>
> Should have read:
>
> close and re-open the workbook.
>
>
> ---
> Regards,
> Norman
>
>
>
> "Norman Jones" <[email protected]> wrote in message
> news:[email protected]...
> > Hi Curt,
> >
> > After protecting the project, to activate the protection, save the
> > workbook, close and re-open Excel.
> >
> >
> > ---
> > Regards,
> > Norman
> >
> >
> > "Curt" <[email protected]> wrote in message
> > news:[email protected]...
> >>I went into vba propertiers and password protected. Still after f8 puts
> >>you
> >> right back into the vba code. No request for password. Is ther something
> >> I am
> >> missing?
> >> Thanks
> >>
> >> "Leith Ross" wrote:
> >>
> >>>
> >>> 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
> >>>
> >>>
> >
> >
>
>
>

DUHH ain't I the dummie
Thanks Curt

"Norman Jones" wrote:

> Hi Curt,
>
> After protecting the project, to activate the protection, save the workbook,
> close and re-open Excel.
>
>
> ---
> Regards,
> Norman
>
>
> "Curt" <[email protected]> wrote in message
> news:[email protected]...
> >I went into vba propertiers and password protected. Still after f8 puts you
> > right back into the vba code. No request for password. Is ther something I
> > am
> > missing?
> > Thanks
> >
> > "Leith Ross" wrote:
> >
> >>
> >> 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
> >>
> >>
>
>
>