Q: s there a way to just read the excel file instead of using the open command? Everytime I run the command I get the following message, even when it isn't open.
A: I'm not aware of a way to do this without opening Excel in the background. But I suspect if you look at your task manager you might see that an instance of Excel running in the background. I see this often when I'm testing iLogic/Excel code and error out in the midst of it. If you kill the process for this phantom instance of Excel, you shouldn't see this issue.
Q: Is there a way to stop it asking the following message at the end of the rule too?
GoExcel.DisplayAlerts = False
Q: The final thing is that sometimes I get the following error when I run the rule. If I don't change anything and run the rule again it works fine. Any ideas?
A: I don't really have a good guess on this, but it might occur if you've errored out on the previous run of the rule without the rule completing?
Thank you once again for your answers. I found the date post that you mentioned but I'm not sure where to put it.
I put it in here but it returns an error. I wish there were more tutorials on iLogic becasue I just feel so helpless.
Dim myArrayList As New ArrayList
For rowCheck = 2 To 1000
Dim myCell As Double
myCell = GoExcel.CellValue("A" & rowCheck)
Dim myDate As DateTime.Now.ToString("d")
myDate = Date.FromOADate(myCell)
Dim curDate As String
curDate = DateString
If myDate = curDate Then
sDescription = GoExcel.CellValue("B" & rowCheck)