Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
query
Is there a way to create a query which can then be run by another user on a
different pc? -- TW |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
query
Yes, but if you're talking about interrogating a mainframe database, the
other site must have access and rights to the data.....MIS usually don't share those things unless requested. Vaya con Dios, Chuck, CABGx3 "Tricia" wrote: Is there a way to create a query which can then be run by another user on a different pc? -- TW |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
query
I have the rights - can you tell me how to do it?
-- TW "CLR" wrote: Yes, but if you're talking about interrogating a mainframe database, the other site must have access and rights to the data.....MIS usually don't share those things unless requested. Vaya con Dios, Chuck, CABGx3 "Tricia" wrote: Is there a way to create a query which can then be run by another user on a different pc? -- TW |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
query
eIt's fairly involved, but you might try turning on the Macro Recorder and
going through the Data GetExternalData...process to actually get the data and then turn off the macro recorder.........then each time you run the macro it should get that same data.........the macro may have to be tweaked at the other location........if you are not in to VBA, this is probably not a good place to start, but a local GURU should be able to do it for you............ hth Vaya con Dios, Chuck, CABGx3 "Tricia" wrote: I have the rights - can you tell me how to do it? -- TW "CLR" wrote: Yes, but if you're talking about interrogating a mainframe database, the other site must have access and rights to the data.....MIS usually don't share those things unless requested. Vaya con Dios, Chuck, CABGx3 "Tricia" wrote: Is there a way to create a query which can then be run by another user on a different pc? -- TW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |