Use VBS/Automation To Detect Password Protection/Read Only

Use VBS/Automation To Detect Password Protection/Read Only

Post by TURX » Fri, 23 Jun 2006 04:07:03


I've got a VBA file that creates an instance of Excel and opens XL files. I'd
like this process to occur completely without human intervention. However,
there are two cases when I see pop-ups that require me to do something:

1) the file is read-only
2) the file is password protected to open

I'd like for my script to bypass these files entirely. Is there a way within
VBS or Excel automation to tell whether a file is password protected or Read
Only?

Thanks.
--
Hmm...they have the Internet on COMPUTERS now!