adding a module to several different workbooks
 

Is there a way to add a module (with a macro) to several workbooks...without
doing by importing file by file..?TIA

adding a module to several different workbooks
 

Open all of you workbooks, and in the VBE, just drag and drop from the
source workbook to each target workbook.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"uriel78" wrote in message
...
Is there a way to add a module (with a macro) to several
workbooks...without
doing by importing file by file..?TIA

adding a module to several different workbooks
 

I meant to add

But shouldn't you avoid all that code replication, and put it in one place,
like an add-in?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
Open all of you workbooks, and in the VBE, just drag and drop from the
source workbook to each target workbook.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"uriel78" wrote in message
...
Is there a way to add a module (with a macro) to several
workbooks...without
doing by importing file by file..?TIA

adding a module to several different workbooks
 

THat's a good solution but I can't do it....I'm not very good at using excel
& VBA...



"Bob Phillips" ha scritto nel messaggio
...
I meant to add

But shouldn't you avoid all that code replication, and put it in one
place,
like an add-in?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
Open all of you workbooks, and in the VBE, just drag and drop from the
source workbook to each target workbook.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"uriel78" wrote in message
...
Is there a way to add a module (with a macro) to several
workbooks...without
doing by importing file by file..?TIA