Password

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hi.
I want to create a worksheet that access data from password protected
worksheet without entering
a password, such as a command that has the password to open.
 
Hi George,
I want to create a worksheet that access data from password protected
worksheet without entering
a password, such as a command that has the password to
Click to expand...
open.

This should do:

Workbooks.Open FileName:="abcd.xls", password:="abcd"

Best

Markus
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Anyone Suggest a Way to Remove a Password from a PST File Without Outlook? 1
Storing and Accessing Data 1
How to bypass password when pasting FROM a protected workbook 3
How to hide password? 1
How to Store Passwords To Multiple Sheets and To Retain thatPasswords When the Workbook IS closed 1
Windows 10 W10 password prob. 2
Help with VB code 2
Different password for different worksheet " Help !" 1

Back
Top