hexagon logo
Register Sign in
  • Replies 9 replies
  • Subscribers 221 subscribers
  • Views 105 views
  • Users 0 members are here
Options
Related

macro or script to autorun PCD2Excel

Adam.rgbsi
Does anyone know how to write a script or macro to auto generate a report at the end of my program?

I know I can use 
EXTERNALCOMMAND/DISPLAY ; C:\PROGRAM FILES\HEXAGON\PC-DMIS 2018 R2 64-BIT\EN\PCD2EXCEL.EXE


But, I don't want to be able to click on anything. I don't know where to start with writing this Marco or script but if anyone had any tips or pointers that would be helpful or even examples. I can work with that and figure it out. Just need a starting point.

My objective is to have the machinist start the part and do nothing else and just have the report auto generate at the end of each program. Create an excel sheet with all the information that PCD2Excel would generate. I simply just want to eliminate the process of clicking on the button.
Parents
  • On newer versions of the software (I'm guessing 2015 and later - can't remember when this feature as added) there is an option to output to Excel. That's under File - Printing - Report Window Print Setup. The third tab is titled Excel. I'm pretty sure that uses PCD2Excel to create the output. If not, it is practically the same. That will auto output the report the way you described.

    If you need to get fancier and use variables to assign special file names or paths for each execution, you can insert a print report command at the end of your measuring routine and put variables in those fields as needed.
  • in reply to Cris_C
    Yes, I'm aware of this. I just want to for the report to be automatically generated in an excel report once the program reaches the end. I was told this can be achieved by making a script or macro. But I'm not sure how to go about this since I'm still new to PCDMIS
Reply Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement