Thank you all for the information, Thanks to LJ I now have runmacro up and working that will help me. Mark, As for the ODBC Data source, unfortunately as I suspect is part of my problem is IT hasn't really properly installed things.....(Or as a result of still running V5 may not have these extras). Apparently there is no ODBC drivers installed on our production machines..(its not listed in Data Source anyhow). I suspect the fact I was missing runmacro as well indicates a lack of full/proper install. I'll see if I can work further with my IT to resolve the ODBC issue as I'd love to play with new ways to interact with data. (I often do batch data changes through ARuser as well (currently using macros). --Kevin
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Latta Sent: Monday, June 09, 2008 9:00 PM To: arslist@ARSLIST.ORG Subject: Re: VBA aruser/Remedy newbie questions ** Kevin, I have been doing this for years and the simplest method that I have found is to use the "AR System ODBC Data Source" available through MS Excel. This ODBC driver is installed/available by default on workstations that have the Remedy User Tool installed on it. The best part is that you can simply record an Excel macro while you establish the ODBC connection to Remedy and define your query criteria through MS Query. Once you have recorded the code you'll have almost everything you need to tailor it and to add subsequent formatting, charting and analysis code for reporting. Here are a few things to keep in mind for security reasons: 1.) Password protect the excel VBA project (in the VB Editor) to protect the login and password information which will be recorded for establishing the database connection 2.) If you opt to return the data to Excel (which isn't necessary for reporting) you will want to set the following Query/Table property: EnableEditing = False This prevents the users from being able to modify the query criteria after it is retrieved from the database by simply right-clicking on the data in the Excel worksheet. Summary of steps for the macro: 1.) From the main Excel menu: Data -> Import External Data -> New Database Query... 2.) In the "Choose Data Source" pop-up window select the "AR System ODBC Data Source" 3.) Provide the ODBC login information when prompted. 4.) Select your query criteria through MS Query which was automatically started. (Select columns, etc.) You can choose to return the data to Excel or to continue editing in MS Query. Note: MS Query is limited in capabilities and will not support all datatypes in Remedy. The format in which the query criteria is recorded is a bit difficult to edit. However you can replace that with a query sting property which allows you to enter plain text that is much simpler to read and edit than the array type construction that it records it in. Let me know if you need any additional help. Feel free to email me directly at [EMAIL PROTECTED] - Mark Latta ________________________________ Date: Mon, 9 Jun 2008 10:17:00 -0600 From: [EMAIL PROTECTED] Subject: VBA aruser/Remedy newbie questions To: arslist@ARSLIST.ORG ** Hi everyone I want to apologize as I think my questions may seem a bit to simple and/or below the level that most of this group is, hoping to have better questions and maybe some answers for other newbies like me. Unfortunately due to my current system limitation/access I am stuck only being able to use VBA and am currently pulling a lot of Data through ARUSER for my reports. Right now the method I am using to pull information is via the following code: ################################ Sub LaunchRemedy(macroname) Dim App Dim ARForm Dim sessionId ' create a new Remedy User Set App = CreateObject("Remedy.User") ' login, username and password sessionId = App.Login("username", "password", False) Call App.RunMacro(sessionId, macroname, 0, 0) ################################# This generally works, I pre-generate my Macro's using VBA and have this call ARUSER and typically dump out my report for the data I need to a CSV that is then picked up and my VBA program continues along. My question would be, if there a way using only VBA that I a. might be able to run a data set, or a macro without having to call the ARUSER program? (This is a problem as after only a few hours of continuous polling (My current report pulls around 500+ unique tickets every 5 minutes) ARUSER runs out of system memory. or b. just to get me started while I hopefully learn some better ways, is there an easy way to close aruser directly? I currently have my code attempt to close pull AR system user into focus after ~40 macro's to close it, and re-open it. The code I am using right now is bad however. ### ' Close Remedy SendKeys ("%F") SendKeys ("x") ### Very bad code, and as I typically wish to have my reports running in the background of my current work machine this can also cause problems... P.S. we are using V5.01 I believe ... I only have access to ARUSER.EXE.. ARTASK.EXE doesn't load for me and I do not have registry access. Also I have no armacro(?) program I have read about in the documentation to play with... TeleTech(r) Kevin Redick | SMG - Service Monitoring Group | Verizon Online Please visit us at http://www.teletech.com ............................................................ This email and any attachments may contain confidential, proprietary and/or privileged information. If you are not the intended recipient, please immediately notify the sender by return email, and delete this communication and any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be subject to criminal and civil proceedings. Unless otherwise stated, opinions expressed in this email are those of the author and are not endorsed by TeleTech Holdings. ............................................................ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ________________________________ It's easy to add contacts from Facebook and other social sites through Windows Live(tm) Messenger. Learn How. <https://www.invite2messenger.net/im/?source=TXT_EML_WLH_LearnHow> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Please visit us at http://www.teletech.com ............................................................ This email and any attachments may contain confidential, proprietary and/or privileged information. If you are not the intended recipient, please immediately notify the sender by return email, and delete this communication and any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be subject to criminal and civil proceedings. Unless otherwise stated, opinions expressed in this email are those of the author and are not endorsed by TeleTech Holdings. ............................................................ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
