how to link to a file that is password protected

T

Tony

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.
 
A

Alex Dybenko (MVP)

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
 
Top