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

Excel Reporting FCF

Edgewise
I am trying to develop an Excel macro to give the min/max measured value for each feature between every sheet. This is working fine so far, when my measured data appears in column E in excel.

The issue I am having is that if I have a routine that reports an FCF dimension, it shifts every column over 1, and my measured values now appear in column D. This renders my macro useless. I need to report FCF dimensions, so I can't uncheck that box on the Excel formatting tab. I have many different programs that may or may not report FCF dimensions, is there a way to report them without reporting the SEG=1 value?
Parents
  • I don't know what it looks like, but does the first line of the output say it is position, length, distance, whatever?

    If so, in code in Excel, read that, if it equals TP, Perp, Profile, etc. get value from D, else, get value from E.

    You are writing code already, use the code to get what you want from where you want. I'm presuming you are writing an actual macro and therefor are using VBA and can read/write/edit it.

    There must be some identifier that gives what you want.
    If not one cell, then read three cells, run an if on the values. If it is pushing one cell to the right for FCF, there is data in a cell for an FCF that is empty in non-FCF features, or vice-versa. If that cell is blank, read data from column E, if that cell has data, read the number from column D. Read the cell into a string variable and do isnull or ="", I don't remember which is VBA, maybe both.

    Its code, it will do whatever you write. Unlike a CMM, you can make it do almost anything.
Reply
  • I don't know what it looks like, but does the first line of the output say it is position, length, distance, whatever?

    If so, in code in Excel, read that, if it equals TP, Perp, Profile, etc. get value from D, else, get value from E.

    You are writing code already, use the code to get what you want from where you want. I'm presuming you are writing an actual macro and therefor are using VBA and can read/write/edit it.

    There must be some identifier that gives what you want.
    If not one cell, then read three cells, run an if on the values. If it is pushing one cell to the right for FCF, there is data in a cell for an FCF that is empty in non-FCF features, or vice-versa. If that cell is blank, read data from column E, if that cell has data, read the number from column D. Read the cell into a string variable and do isnull or ="", I don't remember which is VBA, maybe both.

    Its code, it will do whatever you write. Unlike a CMM, you can make it do almost anything.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement