query
Is there a way to create a query which can then be run by another user on a
different pc? -- TW |
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 |
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 |
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 |
All times are GMT +1. The time now is 12:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com