External data source
 

I use external data in a workbook. When I place it on the server, the
computer I have access to (not my development pc), gives me an error about
the source. When I try to update it to use the network structure it gives me
an error.

Is there a way vba or other to change the query source from "c:\....." to
"\\....." even though I do not have access to the drive myself on the dev
machine? I even tried in the MS Query but unless I actually have access I
cannot make the change.

QB