web query in Macro - how to embedded in file, not a path to c Drive

Hi,

I have a Macro what calls a web query. When I send the excel file to my team members it errors as they don't have the query file
I thought it would be embedded in the excel file, but it uses a path specific to me


How would you change this so any one can use it

When i view existing connection, it is in the work book
ExistingConnections.PNG

Thanks in advance
Mike



Sub Update_WQ_3()
'
' Update_WQ_3 Macro
'

'
Sheets("RAW").Select
Range("A1").Select
With ActiveSheet.QueryTables.Add(Connection:= _
"FINDER;C:\Users\mcarpend\Documents\My Data Sources\DD_GetInitialUsageData.iqy" _
, Destination:=Range("$A$1"))