Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Query path
I have a query from MS Access linked to multiple worksheets. The query path
is changing. Is there an easy way to change the query path without having to relink the query in each spreadsheet. These spreadsheets have proliferated and I'm sure I can't find them all. I want to be able to send the users an "easy fix" rather than having to relink every spreadsheet. The query was linked using query wizard, there is no VBA associated with it. An additional issue is that the query can contain up to 76 fields, but every sporeadsheet does not contain every field |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing the path behind a button | Excel Discussion (Misc queries) | |||
Change the path of a Microsoft Query? | Excel Worksheet Functions | |||
Change the path of a Microsoft Query? | Excel Programming | |||
change query path | Excel Programming | |||
Changing the Path In a Usage Log | Excel Programming |