Hello

I have an employee management spreadsheet that tracks employee hours. I am creating new employees using VBA which includes creating an individual power query (connection only) from their 'hours' table with VBA. What I cannot figure out how to do is append their connection only query to the master power query in VBA instead of doing it manually in the query editor. Is it possible to emulate the "Append Query" command from the power query editor in VBA?

Any attempt to Macro trace/record the command comes up with a blank macro.

Any thoughts/tips appreciated.

TIA

Randall