hexagon logo

Cannot get script to complete

My company just upgraded PCDMIS from 3.7 to 2014. Because our pc's are so old I had to build new ones with W7. My problem is I can't get the pcdmistoexcel_auto script to work. The error I keep getting is "Error on line 11 - class not registered". I followed the directions in the included txt file and it just won't work. Because we're running 64bit windows I found reference that I needed to place the pcdmisutils.dll file in the wow folder, open a cmd prompt, navigate to that folder and run regsvr32 from their so I tried that after the original directions failed. Well that didn't work either. I checked the reference library in VB and pcdmisutils is checked. I also added pcdlrn.tlb as well thinking that might get it to work, but that didn't work either.

I started with Office 2003, then I installed 2007 and now I have 2010 installed per instructions from Hexagons support.

Anybody here have any suggestions?
  • One often overlooked issue in some of these cases is the platform(s). For example, are you running x64 PC-DMIS with x86 Office/Excel?
  • Do you have more than one PC-DMIS version installed?
    In the Registry, is the CLSID value of HKCR\PCDLRN.Application = {781033A0-6032-4D7F-8C38-F427D27BD150} ?
    Do your users have write access to the Registry key HKCR\PCDLRN.Application?

    PC-DMIS tries to write this value when run, but normal users don't normally have the rights to change it, so if for some reason the installation didn't write the correct value there, the script can't find the handle to PC-DMIS.

    If the above questions don't make sense to you, you need to invoke your IT department.
  • I believe the issue is with pcdmisutils.dll on 64bit.

    I did a fix for a client recently where their export tool wouldn't work because of this.

    All the pcdmisutils.dll was actually doing was managing excel (seeing if it was already open etc) of which there were other methods of doing the same thing.