Access to password protected workbook

D

Dr. Schwartz

I have a password protected workbook (DataFile.xls) that I want to access
from File1.xls using a VLOOKUP function. When the user opens the File1.xls I
can avoid the update links by adding this line to an beforeworkbookopen event:

Workbooks.Open Filename:= "File1.xls", UpdateLinks:=3

But then the user gets prompted to enter the password. Is it possible to use
the beforeworkbookopen event to input the password. I don't want the password
entry to be manual.
 

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

update links to password protected workbooks. 1
Password protected and shared workbook 1
how do i loop thru all the worksheets in 2 files one by one 0
Run Macros in a Password-protected workbook? 1
Macro to open, Update links, save and close workbooks 0
Excel macro to open a password protected workbook 9
Password Protection Bug 2
Password to open workbook 2

Top