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

J

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

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