I'm looking to create a workbook connection through VBA but not from a file. I have a connection string that I am going to use to connect to a SQL database, however I'm not having any luck actually getting it to show up on the connections UI.
The logic basically is to
1) Run through sheets
2)...