Excel AVAYA cross

[msnook]

I have a script set up for AVAYA and I want to run this script using EXCEL. I can set it up as a link in excel with a Macro to run the link but that presents a problem as the tool will be used by multipeople at multiple sites and would have to be adjusted on everyones computer for the link to work. The script is below. Is there any way to incorporate this language(or similer) into EXCEL to make it perform this operation? Thank you in advance for any helpful guidance.

Public Sub Main()
DatRange = Inputbox ("This program will display the daily AUX, Summary reports,and log in report. Please enter the date of the reports you wish to see in the format m/d/yy")
'----------------------------------------------------------
On Error Resume Next

cvsSrv.Reports.ACD = 1
Set Info = cvsSrv.Reports.Reports("Historical\Agent\Group AUX Daily")

If Info Is Nothing Then
If cvsSrv.Interactive Then
MsgBox "The report Historical\Agent\Group AUX Daily was not found on ACD 2.", vbCritical Or vbOKOnly, "Avaya CMS Supervisor"
Else
Set Log = CreateObject("ACSERR.cvsLog")
Log.AutoLogWrite "The report Historical\Agent\Group AUX Daily was not found on ACD 2."
Set Log = Nothing
End If
Else

b = cvsSrv.Reports.CreateReport(Info,Rep)
If b Then

Rep.SetProperty "Agent Group","OP Michael Snook"

Rep.SetProperty "Date",DatRange

b = Rep.Run

If Not cvsSrv.Interactive Then cvsSrv.ActiveTasks.Remove Rep.TaskID
Set Rep = Nothing
End If

End If

 

[PHV]

What are cvsSrv and Rep ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Rather than throwing code at us and asking for somthing to do that, exactly what is is that this code is supposed to do? Please post the FUNCTIONAL REQUIREMENTS. Forget code for now.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[msnook]

The coding that I included works with AVAYA to run a report called the Group AUX Daily for a specific person (Michael Snook) and a date of my selection. I am using that data in a daily EXCEL report. My thought was that I could automate the process to run the reports and only open EXCEL to do everything. I can create a link in EXCEL to the script saved elsewhere on my computer and then activate the link to get the desired result. The problem then lies in the fact numerous people will be using this EXCEL document. The link address will be different and instead of going around to everyones computer and setting it up I was hoping to place the coding itself directly into EXCEl and do the same thing. If that is the case I would only need to add a choice as to which person is using the program and it would pull that persons information. My other option would be to create a link to the same file stored on a shared drive that someone could access. That might be the easiest. Let me know if this is more effort than its worth and I will go a different route. Hopefully that clarifies.