+ Reply to Thread
Results 1 to 4 of 4

adding a module to several different workbooks

  1. #1
    uriel78
    Guest

    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



  2. #2
    Bob Phillips
    Guest

    Re: 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" <[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
    >
    >




  3. #3
    Bob Phillips
    Guest

    Re: 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" <[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
    > >
    > >

    >
    >




  4. #4
    uriel78
    Guest

    Re: 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" <[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
    > > >
    > > >

    > >
    > >

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1