Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 22 of 22

Thread: Macro to open password protected workbook..

  1. #21
    New Member
    Join Date
    Apr 2012
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro to open password protected workbook..

    Are you using Windows XP?

  2. #22
    New Member
    Join Date
    Apr 2012
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile Re: Macro to open password protected workbook..

    If you are using XP, try this:

    Sub open_Workbook()
    Workbooks.open Filename:= _
    "C:\documents and settings\user\desktop\Hello.xls", _
    Password:="123"

    Where user in the path is your username. Make sure
    you type in correct file extension for excel file.

    Works like a charm here.
    Just remember you need to protect workbook again before you
    Close it.

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
  •