hexagon logo

PC-DMIS to Excel

I would like a couple of Guru's to sign up to take a look at an Excel Spreadsheet I created to import measurements from multiple parts into one Excel Spreadsheet. This app has been created for use only with PC-DMIS V4.0 and up. I have tested it in 4.0 and 4.1 with the following dims ...

Location, Distance, TP, Profile Surf, Profile Line, Concentricity
Circularity, Perpendicularity and Parallelism.

But it should work with any type of dimension. Basically I dissected the existing source code for the wizard and made it to suit my needs. Before I (or we) release it to the masses I would like a couple of people who would be willing to beta test it in their environments and maybe make some suggestions for improvements. The spreadsheet was written in Office 2003/VB6 although office apps do tend to be backward compatible if you have an older version of office.

Cheers!

t.
Parents
  • Use the following procedure to select the correct PCD library reference depending on the version of spreadsheet and PCD you are using.

    1. Open the Excel spreadsheet.
    2. Select Tools | Macros | Visual Basic Editor. The Editor opens.
    3. Select Tools | References. The References dialog box appears.
    4. Deselect the PC-Dmis 4.2 Object Library check box.
    5. Select the PC-Dmis 4.3 Object library that you have installed on your system.
    6. Click OK.
    7. Select File | Close and Return to Microsoft Excel.
    8. PC-DMIS will now use that object library to load constants and function definitions.
Reply
  • Use the following procedure to select the correct PCD library reference depending on the version of spreadsheet and PCD you are using.

    1. Open the Excel spreadsheet.
    2. Select Tools | Macros | Visual Basic Editor. The Editor opens.
    3. Select Tools | References. The References dialog box appears.
    4. Deselect the PC-Dmis 4.2 Object Library check box.
    5. Select the PC-Dmis 4.3 Object library that you have installed on your system.
    6. Click OK.
    7. Select File | Close and Return to Microsoft Excel.
    8. PC-DMIS will now use that object library to load constants and function definitions.
Children
No Data