If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

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

Thread starter johnny51981
Start date May 19, 2023
Tags

excel power query queries and connections vba

johnny51981

Active Member

May 19, 2023

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.