 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008query
Is there a way to create a query which can then be run by another user on a different pc?  SignatureTW 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 > Is there a way to create a query which can then be run by another user on a > different pc? I have the rights - can you tell me how to do it? SignatureTW > 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 [quoted text clipped - 5 lines] > > Is there a way to create a query which can then be run by another user on a > > different pc? 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 > I have the rights - can you tell me how to do it? > [quoted text clipped - 7 lines] > > > Is there a way to create a query which can then be run by another user on a > > > different pc? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.