hexagon logo

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

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
  • You da man! Thanks Don.

    vpt, thanks as well for heading me in the right direction!

    SOLVED!



    We are always glad to help. I don't visit this forum as often as I should lately. If ever I can help, and I don't respond here, send me a PM and I will get to it as soon as I see it. I am not an expert, but I have a lot of experience in certain areas, including some in automation with Basic.
Reply
  • You da man! Thanks Don.

    vpt, thanks as well for heading me in the right direction!

    SOLVED!



    We are always glad to help. I don't visit this forum as often as I should lately. If ever I can help, and I don't respond here, send me a PM and I will get to it as soon as I see it. I am not an expert, but I have a lot of experience in certain areas, including some in automation with Basic.
Children
No Data