Kevin,
If your up for it then you might try the ODBC access to ARS data. ( An
ARS ODBC driver should have been installed when the User Tool was
installed.) That might be a better programmatic way to get at the
data.
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.
On Mon, Jun 9, 2008 at 12:17 PM, Redick, Kevin
<[EMAIL PROTECTED]> wrote:
> **
> 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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
