I think my query code was wrong but it still works.

[yxz152830]

Gurus,
I recorded a macro and changed it to a loop.
Below is the part where I think should have gone wrong. Basically I forgot to use variable string qname(qname is from day1 to day10) to replace "day1" in the "Data Source=$Workbook$;Location=day1" part.
However, the code ran and gave me the right tables from datasource. I tried leaving "location=" blank or changing it to some random names and the code can't proceed and returns "can't find xxx query" error.
So this means that "Location=day1" corresponds to qname right?
But if it does correspond with qname, which is from day1 to day10 generating 10 different queries, why was code ran without error returning and feeding me the right tables????

ActiveWorkbook.connections.Add2 _
            qname, _
            "", _
            "OLEDB;Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=day1;Extended Properties=" _
            , qname, 6, True, False

 

[yxz152830]

So I tried changing "location=" to different "dayxxx". As long as it is one of the "day1", "day2", "day3" ..... "day10" queries, it doesn't matter. What is the mechanism behind the code?????
As to me, "Data Source=$Workbook$;Location=day1" means that in the previous steps, queries are formed and stored in this workbook. and location should literally be the name of the query. Anyways I'm super confused...