Could anyone tell me if there is a way of querying a password protected workbook please?

I am trying to import data from a password protected workbook using the Excel query method, however the source is password protected and owing to the sensitivity of the data I cannot leave the workbook unprotected whilst importing the data.

I am not averse to using code, as I have already established a way of refreshing this query using VBA, but cannot work out how I can create the query in the first instance.

Thank you