Refresh query with a password protected workbook.

Is it possible to provide me with a macro that will query a workbook which is password protected please. I have tried the following:

Please Login or Register  to view this content.

But I am still being prompted for a password when the workbook containing the source data opens.

Any help gratefully received, thank you.

Hello

Try this line of code.

Please Login or Register  to view this content.

Hope this helps

Cheers

Jim