hexagon logo
Register Sign in
  • Replies 48 replies
  • Subscribers 233 subscribers
  • Views 1369 views
  • Users 0 members are here
Options
Related

This is my Excel Spreadsheet to "pull" dimensions from PC-DMIS

dtmtim
Hello,

Attached to this post is the latest version of the Excel spreadsheet I use to pull dimensions from PC-DMIS. This is especially useful when you have multiple parts to run and you want all the dimensions on one sheet.

There have been a few minor changes from the original. The most significant change was to add support for bonus tolerances on FCF dimensions. Key-ins are supported. Works in V2014.1 and most others, including V4.3

Feel free to suggest improvements but I have limited time and ability.

The original source code was written by Jared Hess at Wilcox a long ,long time ago ... in a galaxy far, far away. This version has been heavily modified (by me) over the years, and fortunately, I haven't completely ruined it yet.

Dimensional results are put into a column on the spreadsheet. Each part you run starts a new column.

This post will replace the one I have in "code samples"

Make sure you enable macros.

You may have to choose the correct library file depending on the version of PC-DMIS you are running.
Parents
  • Use the following procedure to select the correct Pc-Dmis library reference depending on the version of spreadsheet and Pc-Dmis you are using. Note: you may have to search your computer to find the correct location and file name for your library. Mine is in C:\Program Files\WAI\PC-DMIS 2014.1 (release) 64 bit\pcdlrn.tlb

    So the file name you are always looking for is pcdlrn.tlb

    If you have multiple versions of PC-DMIS installed on your PC make sure you select the library for the version you want to use.

    Also, if you have an invalid choice selected you will get a message box when you enable macros that will open the references editor so you can pick the correct one.

    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 current PC-Dmis Object Library check box.
    5. Select the PC-Dmis 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 Pc-Dmis library reference depending on the version of spreadsheet and Pc-Dmis you are using. Note: you may have to search your computer to find the correct location and file name for your library. Mine is in C:\Program Files\WAI\PC-DMIS 2014.1 (release) 64 bit\pcdlrn.tlb

    So the file name you are always looking for is pcdlrn.tlb

    If you have multiple versions of PC-DMIS installed on your PC make sure you select the library for the version you want to use.

    Also, if you have an invalid choice selected you will get a message box when you enable macros that will open the references editor so you can pick the correct one.

    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 current PC-Dmis Object Library check box.
    5. Select the PC-Dmis 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
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement