Kevin, I'm sure there is something better than what you are doing...but in the mean time...get your hands on 'runmacro'...this is a stand alone client that uses the macro as input and closes when its done running the macro....so you should be able to use it to do the work instead of trying to automate the user tool.
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Redick, Kevin Sent: Monday, June 09, 2008 10:17 AM To: [email protected] Subject: VBA aruser/Remedy newbie questions ** 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... TeleTechR 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
