Is there a way to add a module (with a macro) to several workbooks...without
doing by importing file by file..?TIA
Is there a way to add a module (with a macro) to several workbooks...without
doing by importing file by file..?TIA
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" <[email protected]> wrote in message
news:CDQ%[email protected]...
> Is there a way to add a module (with a macro) to several
workbooks...without
> doing by importing file by file..?TIA
>
>
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" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
> news:CDQ%[email protected]...
> > Is there a way to add a module (with a macro) to several
> workbooks...without
> > doing by importing file by file..?TIA
> >
> >
>
>
THat's a good solution but I can't do it....I'm not very good at using excel
& VBA...
"Bob Phillips" <[email protected]> ha scritto nel messaggio
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:%[email protected]...
> > 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" <[email protected]> wrote in message
> > news:CDQ%[email protected]...
> > > Is there a way to add a module (with a macro) to several
> > workbooks...without
> > > doing by importing file by file..?TIA
> > >
> > >
> >
> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks