VBA References Problem

[Owen]

I have just completed creating a word form which has been saved as a template
document and loaded onto another users PC. When the user attempted to run
some of the toolbar macros, a compile error was received.

When i reviewed the error message it indicated that a reference was missing.
The name of the reference was "NCSAddOn 1.7 Type Library".

I noted that the reference library was available on my local PC where i
created the document, so i copied the folder which was called "Earth Resource
Mapping" and placed it within the program files folder on the other users PC.

The document template now functions correctly with no compile errors.

My problem is this:

I do not know where the "Earth Resource Mapping" folder came from that was
located within my program files folder. I never installed it to my knowledge.

Does anyone know know what this folder is?
Does anyone know why my macros are referencing a library within this folder
and why that folder would not be available on other users PCs by default.

Appreciate any advise that can be offered.

Thanks
Owen

 

[Jay Freedman]

I have just completed creating a word form which has been saved as a template
document and loaded onto another users PC. When the user attempted to run
some of the toolbar macros, a compile error was received.

When i reviewed the error message it indicated that a reference was missing.
The name of the reference was "NCSAddOn 1.7 Type Library".

I noted that the reference library was available on my local PC where i
created the document, so i copied the folder which was called "Earth Resource
Mapping" and placed it within the program files folder on the other users PC.

The document template now functions correctly with no compile errors.

My problem is this:

I do not know where the "Earth Resource Mapping" folder came from that was
located within my program files folder. I never installed it to my knowledge.

Does anyone know know what this folder is?
Does anyone know why my macros are referencing a library within this folder
and why that folder would not be available on other users PCs by default.

Appreciate any advise that can be offered.

Thanks
Owen

As usual, asking Google is the first step.

Looking for "NCSAddOn", the results initially look a little scary, since they're
mostly from sites that list spyware and the like. Checking a few of those,
though, it turns out that it's not a threat.

Looking for "Earth Resource Mapping" reveals that the company formerly with that
name is now ERDAS Inc., a publisher of geographic information systems (GIS).
Under their previous name they published an NCSView ActiveX control for
displaying map information in a browser (lots of geek info at
http://www.spatialmapping.com/IWSDoc/html/wysiwig_editor_iws.htm). Most of the
information about it on the Web seems to be related to a security problem in one
version of the control; the most understandable description of this is
http://www.kb.cert.org/vuls/id/589188.

You might have acquired the control and its folder of support files if you
viewed a browser page that included the control.

The reference in your macro project might have occurred if your template
includes this ActiveX control. Try opening the project in the VBA editor,
clicking Tools > References, and looking for the reference in the list. If it's
checked, try unchecking it. If anything in the template is actually using the
control, it won't allow you to uncheck the reference; but if you can uncheck it,
re-save the template.

 

[Owen]

Hi Jay

Your help was great. I disabled the reference and resaved the document as a
template. Everything works as expected now.

Thanks again for your help on this.

Regards
Owen