Create Query from Password Protected Workbook

[JoyC]

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 <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[Trevor G]

Look to record a macro to create the intial query as it then gives you the code. As long as you have the password etc to contect to your source then you can include it in the code, once it establishes the link and brings in the data you can look to break the link so the source data is disconnected.