Here are some quick answers to your questions, you might need to dig a bit for a more complete answer, but hopefully this will help.
Q: How do I get it to match the international form of the date instead of the US one?
You might also search here: http://forums.autodesk.com/t5/Autodesk-Inventor-Cu
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?
I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.
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) myArrayList.add(sDescription) End If Next
Access a broad range of knowledge to help get the most out of your products and services.