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

PC-DMIS 2013 object library? . . . For Excel worksheet . . .

thenettrainer
I have an Excel sheet that's worked for years. Way back to PC-DMIS 3.7.
Went to 4.1, slight mod on the Excel VB code and selected 4.1 object library.
Bingo. Worked fine. Runs on autpo-pilot. Run a PC-DMIS program, when
the program finishes, it dumps the data into Excel. And continues to dump
each time the program runs. Dumps in a couple seconds into the next column.
(Or row, if I have the "ROWS" sheet open.)

We just upgraded to 2013. Now it won't riun. It's looking for ther 4.1 object
library. And it's not in 2013.

Problem is, I can't find the 2013 OL in Developer. No check box for any object library.
But there IS one box checked. It says . . . Missing 4.1 object library.

When I run the Excel sheet, I get an error prompt . . .

Compile error: User-defined type not defined

The following line is highlighted in the code . . .

Dim DIM_Fields(MaxDIM_Field) As ENUM_FIELD_TYPES

As I understand it, that missing definition is defined in 2013 object library . . .

which I cannot find.

Any ideas?
Parents
  • When you try to attach the Type Library (PCDLRN.tlb) to Excel, if its not in the list, as you described, you can try the Browse button to use the explorer dialog to go into that folder and select it manually.

    There is an uncertainty here though, if you are using x64 PC-DMIS and x86 Excel, I am not entirely sure how it will react. This would have been true no matter how it was linked.

    Oh, and un-select the checkbox next to "Missing 4.1...."
Reply
  • When you try to attach the Type Library (PCDLRN.tlb) to Excel, if its not in the list, as you described, you can try the Browse button to use the explorer dialog to go into that folder and select it manually.

    There is an uncertainty here though, if you are using x64 PC-DMIS and x86 Excel, I am not entirely sure how it will react. This would have been true no matter how it was linked.

    Oh, and un-select the checkbox next to "Missing 4.1...."
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement