Results 1 to 15 of 15

Open password protected files in folder using list of passwords

Threaded View

Shift-4 Open password protected files... 07-19-2013, 07:18 PM
TMS Re: Open password protected... 07-19-2013, 07:26 PM
Shift-4 Re: Open password protected... 07-20-2013, 10:29 AM
TMS Re: Open password protected... 07-20-2013, 01:21 PM
Shift-4 Re: Open password protected... 07-20-2013, 03:05 PM
TMS Re: Open password protected... 07-20-2013, 04:06 PM
Shift-4 Re: Open password protected... 07-22-2013, 12:49 PM
TMS Re: Open password protected... 07-22-2013, 12:54 PM
Shift-4 Re: Open password protected... 07-22-2013, 01:01 PM
TMS Re: Open password protected... 07-22-2013, 01:29 PM
Shift-4 Re: Open password protected... 07-22-2013, 03:31 PM
TMS Re: Open password protected... 07-22-2013, 04:13 PM
Shift-4 Re: Open password protected... 07-22-2013, 04:46 PM
Shift-4 Re: Open password protected... 07-22-2013, 05:59 PM
TMS Re: [SOLVED] Open password... 07-22-2013, 06:08 PM
  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2010
    Posts
    17

    Open password protected files in folder using list of passwords

    I want to run a macro that simply unprotects all files in a folder, saves and closes. I have the passwords and related file names and paths in a list.


    This is the macro that sets the passwords based on the list

    
    Dim myB As Workbook
    Dim myPW As String
    Dim myC As Range
    Dim ws As Worksheet
    
    For Each myC In Range("A5", Cells(Rows.Count, 1).End(xlUp))
    myPW = myC.Offset(0, 1).Value
    Set myB = Workbooks.Open(myC.Value)
    myB.Password = myPW
    myB.Save
    myB.Close
    Next myC
    Now I want to figure out away to reverse engineer that code so it will unprotect all the workbooks and save and close them as unprotected.

    Thanks



    Edit: I should also add that it is not necessary to have new macro based on that code above. I will be happy with any code that gets the job done.
    Last edited by Shift-4; 07-22-2013 at 06:01 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Password array to open all password protected workbook in a folder
    By rename in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-07-2012, 05:06 AM
  2. ByPassing Passwords when pulling stats from external password-protected files
    By jameztown in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 05-27-2010, 02:36 PM
  3. How to make Workbooks.Open skip password protected files
    By hoffey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2009, 11:01 AM
  4. open multiple password protected files
    By blackstar in forum Excel General
    Replies: 0
    Last Post: 05-13-2007, 11:56 PM
  5. Replies: 2
    Last Post: 04-15-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1