Classification: UNCLASSIFIED Caveats: NONE One comment.
Try to do as much of any calculations within Remedy ARS. VBA is running on a client and Remedy ARS will be on a much more powerful server. I have run into several site where the first thing said is "My Crystal Reports are slow!" The reason this is always true, is that the creator of the report did his complex calculations within Crystal on the client and therefore slowing down the report. Complex calculations need to be done on the server where there is the power of huge memories and paging. VBA can suffer from the same slowness if put together wrong. Gordon M. Frank DISA\Version FNS -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, December 13, 2007 11:22 AM To: arslist@ARSLIST.ORG Subject: Re: DDE vs. OLE - Resolved I was able to find a decent example in the Remedy KB. I believe I have the information I need to accomplish an Active Link-DDE-Execute/Poke. Of course I've now decided to go the VB route, but it's good to know in case I need it for applications. Thanks to all who contributed. 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 Mayfield, Andy L. Sent: Wednesday, December 12, 2007 2:18 PM To: arslist@ARSLIST.ORG Subject: DDE vs. OLE Is anyone out there using DDE as an Active Link action? If so, I could ready use some help with the syntax. Right now I am trying to accomplish a "Poke", but would love to have information on any and all of the commands. Thanks, P.S. DDE = Deviously Diabolic Entity 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 Mayfield, Andy L. Sent: Tuesday, December 11, 2007 1: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" Classification: UNCLASSIFIED Caveats: NONE _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"