| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking HasPassword property without opening
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking HasPassword property without opening
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking HasPassword property without opening
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| Checking range of cells for entry then checking for total | Excel Programming | |||
| Checking before opening "activate:newwindow" to see if already opened | Excel Programming | |||
| Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
| Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
Hybrid Mode
