I'm sure the users don't have
this.

I think that the users would have that installed on their machine. I
don't believe that it is an optional component.

You can use all of the objects in the extensibility library without
using the reference (the library must be installed on the local
machine but need not be referenced in the project's References list)
by using late binding. That is, instead of declaring a variable with a
specific extensibility type (e.g., As VBComponent), you declare all
the objects As Object. Then, change all the constants (e.g., vb_ext_*)
from the constant name to the numeric equivalent, which you can find
via the object browser in the VBA editor.

Note that user's must have enabled the "Allow Access To The
VBAProject" setting.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Mon, 20 Oct 2008 11:55:02 -0700, Barb Reinhardt
wrote:

I've been asked if it's possible to copy a module from one workbook to
another programmatically. I've used some of the information here

http://www.cpearson.com/excel/vbe.aspx

to do this within one workbook. Right now, the user selects the workbook to
open and copies the code from the workbook that is executing. I'm now
wondering how something like this can be sent out to the users. I
downloaded the Microsoft Visual Basic For Applications Extensibility 5.3
reference to my computer some time ago and I'm sure the users don't have
this.

Without having them save all their files in some central location and me
running a macro to update them all, is there some other way to do this?

Thanks,
Barb Reinhardt