Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Opening a passworded workbook

  1. #1


    I have several workbooks that I work on, and have saved with passwords to protect them, however I now need to allow another workbook to be able to open them in the background to retrieve the data from within.

    My question is can I open these protected workbooks, without having them prompt me for the passwords all the time, I need to keep the data secure but also need to open different workbooks at different times.

    I was hoping that I could just have in my macro something like
    Workbooks.Open FileName:="data1.xls" password="password1"

    Naturally I know all the required passwords.
    But no luck yet

    Any help would be appreciated.

  2. #2


    Tis ok got it

    Marvelous how a simple relook can solve most things )

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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