Checking HasPassword property without opening

's Computer Specifications

Looping through a FileSearch.FoundFiles object's collection, I have all the
filenames in a given directory. If the file has a password, I'd like to
change it to a new value. Can I do this without opening the file?

' pseudocode
Dim fs as FileSearch
If (the workbook corresponding to fs.FoundFiles(i)).HasPassword Then
Open
.Password = strNew
.Save
.Close
End If

Can anyone help?
Sprinks

's Computer Specifications

I don't think so.

Sprinks wrote:
>
> Looping through a FileSearch.FoundFiles object's collection, I have all the
> filenames in a given directory. If the file has a password, I'd like to
> change it to a new value. Can I do this without opening the file?
>
> ' pseudocode
> Dim fs as FileSearch
> If (the workbook corresponding to fs.FoundFiles(i)).HasPassword Then
> Open
> .Password = strNew
> .Save
> .Close
> End If
>
> Can anyone help?
> Sprinks

--

Dave Peterson

's Computer Specifications

Thanks, Dave.

Sprinks

"Dave Peterson" wrote:

> I don't think so.
>
>
> Sprinks wrote:
> >
> > Looping through a FileSearch.FoundFiles object's collection, I have all the
> > filenames in a given directory. If the file has a password, I'd like to
> > change it to a new value. Can I do this without opening the file?
> >
> > ' pseudocode
> > Dim fs as FileSearch
> > If (the workbook corresponding to fs.FoundFiles(i)).HasPassword Then
> > Open
> > .Password = strNew
> > .Save
> > .Close
> > End If
> >
> > Can anyone help?
> > Sprinks
>
> --
>
> Dave Peterson
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA - checking for existance of a property	B	Microsoft Excel Programming	2	24th May 2008 05:03 PM
Conflicting used space information when checking the drive property against marking all files and checking the marked file properties.	elloko	Windows XP Configuration	3	19th Dec 2004 05:34 AM
Checking validity of a property on set()	Sam Martin	Microsoft C# .NET	3	3rd Nov 2004 03:52 PM
property dirty checking	Erik Frey	Microsoft ADO .NET	3	23rd Mar 2004 05:05 PM
open doc with vb but need to see if haspassword first?	mac	Microsoft Word Document Management	1	12th Feb 2004 11:14 PM