Tom,

I put that in at some point thinking it was necessary because I was
launching Word and
Mail Merge from Excel in a couple of my functions. From what you quote
it seems
it has nothing to do with ail Merge. I have unchecked it on my
development machine and tested
the functions that use MM. Seems to work OK. Tomorrow I'll test it on
the other machine.

Thanks.

Ed

"Tom Ogilvy" wrote in message
...
this is from MSDN

Merge Modules
Merge modules provide a standard method by which developers deliver
shared
Windows Installer components and setup logic to their applications.
Merge
modules are used to deliver shared code, files, resources, registry
entries,
and setup logic to applications as a single compound file.
Developers
authoring new merge modules or using existing merge modules should
follow the
standard outlined in this section. . . .

My guess would be that you don't need this and it has nothing to do
with
Office - I don't know your application, so I can't say for certain,
but your
comments certainly imply that it doesn't I would suggest unchecking
it on
your machine and saving your file.

I know for certain it isn't a standard library need to run office.
It
isn't on any version of Excel I use.

--
Regards,
Tom Ogilvy




"Ed" wrote:

The missing file is apparently mergemod.dll in C:\Program
Files\Common
Files\Microsoft Shared\MSI Tools on my development machine, which
seems to be running Excel 2002 SP3. There is no such file or
directory
on the 2nd machine
which is running without any SPs.

Ed

"Ed" wrote in message
...
You're right. It says that Microsoft MSM Merge Type library is
missing. Wonder why?
As I said, I did a repair of the installation off the Office 10
CD.
Also, the test machine
is my wife's, in a room across the hall. I'm a bit worried that
it
might fail on another machine
a bit more difficult for me to get at and fix.

Thanks to Tom and others who identified the problem.

Ed

"Tom Ogilvy" wrote in
message
...
on the problematic machine, after the error, go into
tools=References in the
VBE and you should see one or more references marked as MISSING.

Fix these references as they are the source of your problem
(high
probability they have nothing to do with the string library).

Or look in your own machine and see what references you have in
this
workbook that are not likely to be in your users environment.

--
Regards,
Tom Ogilvy