I have run the code and it certainly seems to work but I don't understand how it can. Query references a linked table SITES_INFO_GOOGLE.mdb which has a link path C:\Data\GE. I do not have such folder nor mdb file. I try to open the query object and it triggers 'invalid path error', yet the code opening recordset based on the same query works. Can you explain this?
There is no use of SITES_INFO_GOOGLE.mdb, please run the code, when we enter the cell name, it's get the neighbor list from Links declared and sets the recordset. by using do while loop each and every neighbor created the line by using the KML Header, KML body and KML footer.
In this, my query is, we need to create the one color for 1st 5 neighbors and the remaining with other color,
if you still have doubt, please take help from any other experts but please help me to send the code,
Thanks....