Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
password protected
Hello,
I need to write a program to open and update a bunch of excel documents. problem is, that some are password protected. and if i hit them, then the user password dialog opens. is there a way to tell if a document is password protected? an open command? so i know to skip that document? thanks |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
password protected
Dave Peterson suggested this to as similar question:
Dim wb as Workbook For i = 1 To .FoundFiles.Count Set wb = Nothing On Error Resume Next Set wb = Workbooks.Open(Filename:=.FoundFiles(i), _ Password:="", writerespassword:="") On Error GoTo 0 If wb Is Nothing Then 'don't do anything, it wasn't opened! MsgBox "not opened" Else 'do your real work here MsgBox "it's open" End If Next i This was using the FileSearch Object, but you can use the approach with any list of files. -- Regards, Tom Ogilvy "greg" wrote: Hello, I need to write a program to open and update a bunch of excel documents. problem is, that some are password protected. and if i hit them, then the user password dialog opens. is there a way to tell if a document is password protected? an open command? so i know to skip that document? thanks |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
password protected
awesome!
I will give it a try "Tom Ogilvy" wrote in message ... Dave Peterson suggested this to as similar question: Dim wb as Workbook For i = 1 To .FoundFiles.Count Set wb = Nothing On Error Resume Next Set wb = Workbooks.Open(Filename:=.FoundFiles(i), _ Password:="", writerespassword:="") On Error GoTo 0 If wb Is Nothing Then 'don't do anything, it wasn't opened! MsgBox "not opened" Else 'do your real work here MsgBox "it's open" End If Next i This was using the FileSearch Object, but you can use the approach with any list of files. -- Regards, Tom Ogilvy "greg" wrote: Hello, I need to write a program to open and update a bunch of excel documents. problem is, that some are password protected. and if i hit them, then the user password dialog opens. is there a way to tell if a document is password protected? an open command? so i know to skip that document? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to retrive password protected worksheet but forgot password? | Excel Worksheet Functions | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
Password protected | Excel Programming | |||
VBa, Password protected sheet fails to get unprotected with the same password | Excel Programming |