vba Connection issue for query table

[reimbursement]

I need to be able to be able to change the file location of a .prn file to represent where the user may have it mapped on their computer.

With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;I:\PROJECTS\waytd.prn", Destination:=Range("A1"))
Using the thisworkbook.path does not work nor does defining the file address.

For example my drive is mapped as I: whereas my co-worker's drive is mapped as F:. Hard coding will not work.

Any Suggestions?

 

[SkipVought]

reimbursement,

You can use Application.GetOpenFilename to have the user locate the .prn file.

Then use THAT path in your connect string.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}