hexagon logo
Register Sign in
  • Replies 10 replies
  • Subscribers 30 subscribers
  • Views 141 views
  • Users 0 members are here
Options
Related

Script External Software auto run by PCDMIS

Cortarelli
Hello All !

I´m working in an excel automation of data collection directly from PCDMIS. Every communication is finished but my idea is create a system 100% automatic.

Also I already created an executable program (.EXE) to execute the excel (at PCDMIS) macro directly but I still need press a button to start the macro.

I have a question yet:

How Can I to create a code to auto execute at PCDMIS ?


For example: We use the QS-STAT Converter in our measurements and PCDMIS we use at final of EXE insertion the \A (inverted bar + A) to auto execute.

I would like to know how I can to insert it in my code.

Thanks.

Raphael
Parents
  • My simpleton way to do this would be to write a .txt file from PC-DMIS right before calling the .exe. Just a blank .txt file, C:\TEST.TXT, with no data in it.

    When excel opens, the macro checks for the existence of this .txt file. If it does exist, run the macro and import the PC-DMIS data, then delete the .txt file. If it does not exist, the excel file is opening only for viewing, not for importing of data.

    There are surely better ways to do this, though.
Reply
  • My simpleton way to do this would be to write a .txt file from PC-DMIS right before calling the .exe. Just a blank .txt file, C:\TEST.TXT, with no data in it.

    When excel opens, the macro checks for the existence of this .txt file. If it does exist, run the macro and import the PC-DMIS data, then delete the .txt file. If it does not exist, the excel file is opening only for viewing, not for importing of data.

    There are surely better ways to do this, though.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement