-
I would like to have these combined into fewer files, but the people requesting these templates do NOT want that. So, I need to work with what I have.
They also recently made changes that affect the text and the userforms in the letters (changes are not the same in all letters), so I want to make my life easier and open a group of them at one time and unlock them...all in one keystroke (the macro).
I put the "\" in and all the files in the selected folder will open now, however, they are still locked. What do I need to change to get the macro to unlock each of them as they are opened, or is that not possible? Here's the part of the code that I added the password into:
[vba]Do While getFile <> ""
strFile = path & getFile
Documents.Open FileName:=strFile, passwordtemplate:="mypassword"
getFile = Dir
Loop
[/vba]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules