hexagon logo

Help with OLE Automation

Now that I have information in a way that imports and exports the information correctly, I have been tasked with creating an OLE to automatically import the data into the SPC software. I have one that sort of works (as in opens the program, logs in, opens the right collection plan, etc) and I can get put in static information, but I am unsure how to call the information out of PC DMIS to have it be placed in the spots we need in the SPC software being used.

Has anyone else done this? Can anyone explain to me how find the variable and the measurement output in PC DMIS? I am using version 4.2 if that helps any.

Thanks so much.
Parents
  • I can't get this to run, due to a syntax error in the last line. Why it is saying that ending the sub is a syntax error, I don't know becaue I declared it first toward the top. And I can't seem to find a dangling If statement either. Any thoughts?

    And then, I also found out that I can't simply do what we have been doing because we need the AX part of this added into how we are seperating out the variables. In some programs the StrDimID is the same and only seperated by the AX, or what I currently have labeled as the StrDimType (the D,M,Y,X,Z, etc). Would adding that in be Set StrDimType = StrDimID.Type? And then adding that at the MyReading1=StrDimID.StrDimType.StrDimMeasure?
Reply
  • I can't get this to run, due to a syntax error in the last line. Why it is saying that ending the sub is a syntax error, I don't know becaue I declared it first toward the top. And I can't seem to find a dangling If statement either. Any thoughts?

    And then, I also found out that I can't simply do what we have been doing because we need the AX part of this added into how we are seperating out the variables. In some programs the StrDimID is the same and only seperated by the AX, or what I currently have labeled as the StrDimType (the D,M,Y,X,Z, etc). Would adding that in be Set StrDimType = StrDimID.Type? And then adding that at the MyReading1=StrDimID.StrDimType.StrDimMeasure?
Children
No Data