How to know if the XLS or DOC files is password protected?

[dennis22]

Hi to all!

Is it possible to determine if an XLS or DOC file is password protected. I have this routine that prints all attachments. I encountered an XLS file that is password protected and end up with errors when opening it.

Thanks!

 

[Mike Lewis]

Dennis,

Yes, this is easy. In Word, the document object has a property, HasPassword, which is either true or false.

I'd guess that an Excel workbook has the same.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[dennis22]

Thanks for your reply Mr. Mike!

I have seen the property HasPassword and excel has it too, however the document or workbook should already be open before I could perform the HasPassword property. Is it possible to know if the xls or doc file has a password or not before openning it. Something like;

if DoesXlsHasPassword("C:\TEST.XLS")
--- ignore it and ask the password later
else
--- open it and start printing
endif

Is there any workarounds or any ideas you can share on how to deal with it. My apologies for asking a stupid question.

Thanks again!

 

[alvechurchdata]

I encountered an XLS file that is password protected and end up with errors when opening it.

Can you use a Try...Catch structure and give the user a friendly warning about the password protection when you detect this error number?

Geoff Franklin

http://www.alvechurchdata.co.uk