Andy, As long as he has the Remedy ODBC installed on the client PC that needs to query the ARSystem he will be ok. The Get External Data menu choice in Excel will be the starting point to create the appropriate query and that will stay with the spreadsheet. There is no OLE manipulation needed, it's all pretty transparent to the user. Other that logging into the ARSystem server and running the query it is almost autonomous. You do need to refresh when the file is opened again but even that can be set to automatically refresh in Excel. The Excel file will create an external query file that it accesses to retrieve the data from ARS. As long as you keep that file around you will be all set. I have created dummy accounts in ARS for just such purposes. They are Read Restricted so more than one person can access at a time from different clients. Their group access is such that the end user only sees the fields that they need to complete the query.
John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, December 11, 2007 3:11 PM To: arslist@ARSLIST.ORG Subject: Re: DDE vs. OLE I thought about having the data exported to a temp.csv file for him to grab and map the correct data, but I was hoping to be able to do it myself from within Remedy. Is OLE even capable of performing such a task? If not, I may have to go the other route. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Tuesday, December 11, 2007 1:51 PM To: arslist@ARSLIST.ORG Subject: Re: DDE vs. OLE Andy, Is it a requirement for ARS to push the data? Ask the excel owner to create a query that retrieves the data. They have control of the Excel file and you can control what they query via the ARS account and permissions setup for this action. HTH, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, December 11, 2007 2:23 PM To: arslist@ARSLIST.ORG Subject: DDE vs. OLE I have a need to have some data from a form sent to an existing excel spreadsheet. I was thinking of using DDE, but from what I've read it sounds as though I may be better of in the long run using OLE. I wanted to be sure OLE would do what I needed before I wasted my time trying. I've been asked to see if I can have Remedy open a pre-existing spreadsheet (lots of VB in the background) and place certain data from a form into the correct cells on the spreadsheet. I have no control of the spreadsheet itself, but I might be able to get the owner to make modifications if I need to. Is this possible using OLE? Tanks All, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"