+ Reply to Thread
Results 1 to 3 of 3

Need some VBA that attaches an exported module to the active workbook

  1. #1
    Registered User
    Join Date
    03-08-2013
    Location
    Derbyshire
    MS-Off Ver
    Excel 2003
    Posts
    46

    Need some VBA that attaches an exported module to the active workbook

    Hi,

    Im Creating Multiple XLS with a macro. Each XLS needs a macro in worksheet one so other users can use them. Im looking for some code that takes my exported module and adds it to the active workbook.

    If any one has any ideas on this I would be very grateful

    Debbie

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Need some VBA that attaches an exported module to the active workbook

    Something like this to import previously exported code.

    Please Login or Register  to view this content.
    How are you creating the multiple xls's? Could you not use a tempate which already contained the code?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-08-2013
    Location
    Derbyshire
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: Need some VBA that attaches an exported module to the active workbook

    Hi, Sorry I hadnt replied to this thread. For some reason I couldnt get into the web site at all from any computer I tried. Very strange. Now its working again.

    I have resoved this isue in the mean time though.

+ 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