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.
............................................................
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
