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

PC-DMIS 2014 + Leica TDRA6000 + VBA/Excel

misch
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
  • Thanks for your answers.
    @
    What i've tested so far is the export to a basic file and copy the code to VBA. But the only thing this does is to write the copied features to the active partprogram.
    With this method i think it is not possible to switch things like "ATR" or "Point only mode" on or off. Because they will not be reported in the edit window. So they are not included in the exported basic code.

    I'm not sure if i'm right with this conclusion.

    @
    The only switch i have found in the help so far is for Probe Compensation.

    PartProgram.OldBasic.ProbeComp (PCD_OFF)

    or

    PartProgram.OldBasic.ProbeComp (PCD_ON)

    I also still haven't figured out how to let the machine take a hit (execute a measurement at a RRR1,5" target) shortcut: CTRL + H



    misch
Reply
  • Thanks for your answers.
    @
    What i've tested so far is the export to a basic file and copy the code to VBA. But the only thing this does is to write the copied features to the active partprogram.
    With this method i think it is not possible to switch things like "ATR" or "Point only mode" on or off. Because they will not be reported in the edit window. So they are not included in the exported basic code.

    I'm not sure if i'm right with this conclusion.

    @
    The only switch i have found in the help so far is for Probe Compensation.

    PartProgram.OldBasic.ProbeComp (PCD_OFF)

    or

    PartProgram.OldBasic.ProbeComp (PCD_ON)

    I also still haven't figured out how to let the machine take a hit (execute a measurement at a RRR1,5" target) shortcut: CTRL + H



    misch
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement