how to link to a file that is password protected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create reports in Access by linking to an Excel file. However the
excel file is password protected, how can I bypass this, I really don't want
to remove the password from the excel file.
Thanks.
 
You can open Excel first using CreateObject("Excel.Application")
Then open your excel sheet there, providing password
Now you can link to this excel file from excel
HTH
 
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

Excel Protection 2
Need to be able to link to a Password Protected Workbook 1
Can I link an Access table to a Password protected Excel Workbook? 2
Windows 10 W10 password prob. 2
Are password protected WiFi networks secure? 3
Excel Excel macro and passwords 3
Link to table from Protected Access Database 1
How to Unlock Excel Workbook protected by MACRO Password 6

Back
Top