You can't open/import data from password protected workbook (open password). Probably you'll need any VBA to "open" this workbook, write password there, then the rest....