K
Keith Ralston
Is there any way to detect when an XLS is password protected?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Otto Moehrbach
Keith
Something like this perhaps:
Sub testme02()
Dim wks As Worksheet
Set wks = ActiveSheet
With wks
If .ProtectContents _
Or .ProtectDrawingObjects _
Or .ProtectScenarios Then
MsgBox "oh, oh. Somekind of protection"
End If
End With
End Sub
HTH Otto
Something like this perhaps:
Sub testme02()
Dim wks As Worksheet
Set wks = ActiveSheet
With wks
If .ProtectContents _
Or .ProtectDrawingObjects _
Or .ProtectScenarios Then
MsgBox "oh, oh. Somekind of protection"
End If
End With
End Sub
HTH Otto
K
Keith Ralston
Can this be done before I attempt to open the spreadsheet?
I need to process a large number of XLS files. I want to note pwd
protected files as exceptions. I am using Automation, not VBA as you
have indicated below.
I need to process a large number of XLS files. I want to note pwd
protected files as exceptions. I am using Automation, not VBA as you
have indicated below.
D
Dave Peterson
Otto's code checks for worksheet protection. It kind of sounds like you want to
check for the file|open type of protection.
I'm not sure how you're automating this (VB??), but if I were doing it in
excel's VBA, I could do try to open it with a password of "" and if it failed,
it had a real password:
Here's a link that uses Excel to make a report for each workbook in a folder:
http://groups.google.com/[email protected]
check for the file|open type of protection.
I'm not sure how you're automating this (VB??), but if I were doing it in
excel's VBA, I could do try to open it with a password of "" and if it failed,
it had a real password:
Here's a link that uses Excel to make a report for each workbook in a folder:
http://groups.google.com/[email protected]
T
timatey
There is free utility to searche for password protected documents
(Word, Excel) on your computer http://lastbit.com/findpswdoc.asp
(Word, Excel) on your computer http://lastbit.com/findpswdoc.asp