Connection String Data source

Connection String Data source=Z:\myfolder\data\abc.xlsx

How to edit the connection string, so that I can connect the abc.xlsx at the current direction and ignore the physical path.
Expected connection path: Connection String Data source=abc.xlsx
I tried above, but failed.

Would it be

"Data Source=" & Thisworkbook.Path & Application.PathSeparatoor & "abc.xlsx"

Hi Bob, thanks for advice.
I tried but failed. Pls clarify if "PathSeparatoor" is typo mistake? should be "PathSeparator" ?
Anyway, I try both spelling but failed too.
pls refer to my screendump where I try to edit.