hexagon logo

PC-DMIS 2014 + Leica TDRA6000 + VBA/Excel

Hello,
i have searched in the Forum for the functions i need, but didn't found anything that fits to my needs.

I tried out some code in VBA/Excel to get values of measured points in the partprogram and writes it into cells in my Excel-sheet. (The code runs through the whole partprogram and reads out every command) So far everything runs fine.

But now i need another functionality.

For example:
- switch Probe compensation on/off
- switch Point only mode on/off
- switch ATR on/off
- Take a Hit with the TDRA6000
- switch between measure mode (simple/average)
- paste the values of the last measured Point into Excel
- create constructions (for example a circle from the last 5 measured points)
- create dimensions (for example a distance between the last 2 measured points)

Is it possible to realise these functions with VBA/Excel and PCDLRN?

Thank you in advance!

misch
Parents
  • It should be possible. Most seasoned script writers have recommended to create a PCD program with the command you're interested in and then export the PCD program out to basic, FILE | EXPORT | BASIC. It creates a file you can open in Notepad, copy and paste the code of importance to your VBA program, you may have to edit it a little to suit. Hope that helps and welcome to the forum!
Reply
  • It should be possible. Most seasoned script writers have recommended to create a PCD program with the command you're interested in and then export the PCD program out to basic, FILE | EXPORT | BASIC. It creates a file you can open in Notepad, copy and paste the code of importance to your VBA program, you may have to edit it a little to suit. Hope that helps and welcome to the forum!
Children
No Data