Hi.
New to forum.
I have a number of Queries (3) consisting of linked Worksheets.
I am trying to read their source file paths in VB ... as I have another routine that each time the User refreshes the data and uses the VB code to manipulates it .... it copies the source file and renames it with a Date Time stamp.
I can see all the Connections that are there by use of
Dim conn As WorkbookConnection
For Each conn In ActiveWorkbook.Connections
Debug.Print conn.Name
Next conn
I cant seem to find a way to read the "Connection" file source. Read a lot of other posts but I am sure it will be blindingly obvious when explained. Thanks in advance.
Bookmarks