hexagon logo

Writing/Reading a .txt file

This is very much a VB question not related to PC-DMIS. There is so much information out there for VB that I find it very hard to locate a good example of what I want to do.

I have a script at the beginning and end of my part program. I would like to get the total runtime of the program. I have a way to get systemtime in each and put it into seconds and such, thanks to this message board.

I do not want to write the beginning time to a variable and have it go through the part program. What I wanted was a temporary .txt file or something similar that I could write the begintime value (in seconds) to. The second script would grab this value and use it. The .txt file either needs to be cleared or overwritten by the new begintime number every execution. How do I code this?

My goal is to take these values and use them to calculate CMM run time for the day in Excel. Can I export the Total Runtime number I get in the second script to Excel? It will probably be easier to google information for this; I will update this post if I find what I am looking for.

Thanks!
Parents
  • I would think that the easiest way to get it into excel would be to go the log file route that cmmguy suggests. If you set it up correctly a comma seperated log file imports very cleanly and easily into Excel. Then you don't have to muck around with opening the excel page reading the worksheet to find your next avaliable line placeing the data and then updating the graph all from within your script.

    Are you using Cypress or some other program for creating your scripts?
Reply
  • I would think that the easiest way to get it into excel would be to go the log file route that cmmguy suggests. If you set it up correctly a comma seperated log file imports very cleanly and easily into Excel. Then you don't have to muck around with opening the excel page reading the worksheet to find your next avaliable line placeing the data and then updating the graph all from within your script.

    Are you using Cypress or some other program for creating your scripts?
Children
No Data