Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some help in re-organising data from external source | Excel Worksheet Functions | |||
UNC for external data source | Excel Discussion (Misc queries) | |||
linking to external dbf data source | Excel Discussion (Misc queries) | |||
inserting rows through external data source | Excel Discussion (Misc queries) | |||
Pivot and changing External data source | Excel Discussion (Misc queries) |