Hello everyone, I am super new to Excel so I am not sure how to do this. I downloaded a script that will pull some call data for some agents and display them in Excel. I would like to have the Date and Name info be something that is read from the a cell itself and then used by the macro.

For example, the Agent Name is in Cell B1 and the Date is on Cell A4. How do I make it so that the value in Cell B1 drives what is in agentName and the value in Cell A4 drives what is in myDate?


Sub Agent_Summary()
Dim cvsApp As Object
Dim cvsConn As Object
Dim cvsSrv As Object
Dim Rep As Object
Dim Info As Object, Log As Object, b As Object

Set cvsApp = CreateObject("ACSUP.cvsApplication")
Set cvsConn = CreateObject("ACSCN.cvsConnection")
Set cvsSrv = CreateObject("ACSUPSRV.cvsServer")
Set Rep = CreateObject("ACSREP.cvsReport")
serverAddress = "192.168.1.1"
mydate = "-1"
UserName = "admin"
passW = "password"
agentName = "agent"