Password access on User Access file

[knightwriter]

Hi all,

I have recently added a password to my excel user access file and when I reload the script I get the following script error (below).

How do I use the script to run the password and look up the user access file?

many thanks

[Gysbert_Wassenaar · Accepted solution]

Use an odbc connection to the excel file so you can specify a user and password. See this discussion: load a Password protected Excel File to QlikView

[avinashelite]

Check this threads

How to open Password protected Excel file in qlikview?

load a Password protected Excel File to QlikView