VBA - Loading Connected Data to Worksheet and then back to Connection only

[johnny51981]

Does anyone have a VBA solution that would take a Connection only (Excel Power Query) and change it to a data table on a worksheet? And then the same in reverse, data table back to Connection only.

I have a rather large file that I refresh each morning, and it includes an Archive Power Query. The data displayed on the Archive Power Query doesn't change until I update the line in the sand date, maybe once every 3 months. So I would like to keep my Archive Power Query saved as a Connection only, only to unearth the data when needed...and then put it back when I'm done with it.

Thanks in advance.