Installing Active X component

[Vince]

I use the Extended Listview control (extlvctl.ocx) in my macro. When I
distribute the template, I need to ensure that the OCX file is installed and
registered in the user's computer. What would be the easiest way to do this?

a) Create a setup package that registers the OCX on the machine and updates
Normal.dot (attaches itself). If so, could somebody please tell me how to go
about doing this.

b) Supply the OCX and the DOT to the user along with a batch file that
registers the OCX using the Regsvr32 command?


The end users are not very adept at using computers. They only know to use
Word.

Thank you for any leads.

Vince

 

[Jonathan West]

Hi Vince,

I use the Extended Listview control (extlvctl.ocx) in my macro. When I
distribute the template, I need to ensure that the OCX file is installed
and
registered in the user's computer. What would be the easiest way to do
this?

a) Create a setup package that registers the OCX on the machine and
updates
Normal.dot (attaches itself). If so, could somebody please tell me how to
go
about doing this.

b) Supply the OCX and the DOT to the user along with a batch file that
registers the OCX using the Regsvr32 command?


The end users are not very adept at using computers. They only know to use
Word.

First of all, don't attempt to modify or overwrite users' normal.dot
templates. Instead, put your code into a separate template. See this article
for why.

Distributing macros to other users
http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm

Second, if your users aren't adept at computers, you need to provide them
with the simplest possible means of installing the files. Ideally, something
where they just start a program and everything automatically gets copied to
the right place and registered. With anything more complex, you are setting
yourself up for the need to go round each computer and do the installation
yourself. That suggests using option A, but installing an extra template
instead of modifying normal.dot.