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

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.

You've been reading PCD2EXCEL

I've also made a spreadsheet like this, although yours have some more functionality than mine. Interesting to see someone else's take on a common problem.

A little tip: Your clearing of all the cells is quite slow, try the following technique instead (it's always faster to work on many cells - a Range - at once):

You've been reading PCD2EXCEL

I've also made a spreadsheet like this, although yours have some more functionality than mine. Interesting to see someone else's take on a common problem.

A little tip: Your clearing of all the cells is quite slow, try the following technique instead (it's always faster to work on many cells - a Range - at once):

'
' Clear result
'
  Range("A7", Cells.SpecialCells(xlLastCell, xlNumbers)).Select
  Selection.Clear
  Range("A1").Select

Nice, thank you. I knew there was a better way to handle that I just haven't had the time to dig into it.

That is a great form, thanks for sharing.

I can't download the zip-file.

Does anyone know the trick how to?

Thank you for this.

When I try to open the zip file I'm prompted to log in again. Do I need special permission to access the file?

Nice, thank you. I knew there was a better way to handle that I just haven't had the time to dig into it.

Sure you did, sure....lol

any user instructions for us less excel savvy folk...?

Everything works now - I wonder why.....