Andy and Carey, We are not actually coding in VBA, just using it. I've used it as ad-hoc reporting when I wanted a something a little more involved that I could get out of a raw ARS search and report. It uses the view so you don't need to know Txxx and Cxxxxxxxxxxxxx numbers. And before I built import forms for Request ID matching I used Excel queries to retrieve the Request ID, match it to my asset tag spreadsheet entries and import it directly into the Asst form ( with arimport.exe).
When you have the ARS WUT installed on your local Window$ machine you have access to the AR ODBC driver. Excel can access the different ODBC connections available on your PC. The Data menu in Excel lets you connect a spreadsheet to external data. By making the connection to the ARSystem via the AR ODBC you are using the API to retrieve data. The onus is on the people requesting the data from Remedy to keep their file updated. All you need to provide is an account with permissions. They can use any legitimate account in the system. We just provide a Restricted Read account so we can control access permissions. Now if you don't have ARUser installed there must be a way of putting the necessary files on the PC so the ODBC connection can be used. I just never went that far with it. 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 Carey Matthew Black Sent: Wednesday, December 12, 2007 8:30 AM To: arslist@ARSLIST.ORG Subject: Re: DDE vs. OLE Andy, It is my understanding that OLE can do such things. Here is the rub.... You will have to work with the "file owner" to establish where you dump your data to and what to call after you have dumped it. (some VBS in the file) And when they want you to start dumping the data "somewhere else" or in "some other format" then you have to be involved again. Another rub is that OLE is Excel version dependent so when you have an active link set up for Office 2000 it may or may not work in office XP. However, if you set it up using Office XP then it will most likely NOT work with Office 2000. You would be relying on Micro$ofts idea of forward and backwards compatibility. However, what John is suggesting (sounds to me to be like) is that they already have invested resource in VBA so they can programmaticly get the data from the AR ODBC driver. This would shift the responsibility totally to the VBA programmer and should allow them to have ultimate flexibility with what they do with the data in Excel or other formats/places. I even remember some sample VBA code to interact with the Remedy( pre [EMAIL PROTECTED]@# days) ODBC driver, but I can not find it at the second. ( Maybe someone from the List can dig up an example??) HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. > -----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"
