How do I link a password protected excel file in access?

[Janet]

I have an Excel workbook with a password to open. I need to use it as a
linked table in an Access 2003 database. The error I get is that it cannot
decrypt the file.

 

[John Nurick]

Hi Janet,

As far as I know, Access's Jet database engine can only link to a
protected workbook if it is already open in Excel.

You can open it manually or write code that launches Excel and opens the
workbook using Excel's Workbooks.Open method, which takes a password
argument.