EXCEL linked table password problem

[morg1980]

I have a Access DB with a linked table in, the table is in an excel password protected worksheet. How can i store the password in the access db so it will be accesible, if i try to open the linked table in access, i get an error "could not decrypt file", with no option to enter the password.

any ideas greatly appreciated

 

[FLabrecque]

You posted 4 times the same question in the last 24 hours. It's not because you have fallen on deaf ears.

I don't know how to give the password through VBA. On the other hand, you could delete the link, and relink again and again.