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.
You can add an auto execution in your Excel macro :
In the "ThisWorkboot" window, you just write :
Private Sub Workbook_Open()
(The name of your Excel macro)
End sub
You can add an auto execution in your Excel macro :
In the "ThisWorkboot" window, you just write :
Private Sub Workbook_Open()
(The name of your Excel macro)
End sub