+ Reply to Thread
Results 1 to 2 of 2

Synchronize module between Workbooks

  1. #1
    Registered User
    Join Date
    08-22-2011
    Location
    Berlin
    MS-Off Ver
    Excel 2010
    Posts
    51

    Synchronize module between Workbooks

    The following procedures allow to keep all components of one Workbook in synch with those in another one provided the component in the source Workbook exists in the target Workbook. All component's code is transferred by line with the exception of UserForms which are transferred via Export/Import in order to synchronize also a UserForm's design.
    Note: The used module "mExists" can be found here.

    Copy the below into a standard module and don't forget the required references.
    Please Login or Register  to view this content.
    Last edited by Warbe; 08-26-2019 at 01:33 PM. Reason: link to module mExists added

  2. #2
    Registered User
    Join Date
    10-24-2013
    Location
    hcm
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Synchronize module between Workbooks

    Nice tip, thank you so much !

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying VBA Modules Between Workbooks
    By Jenn68 in forum Excel General
    Replies: 8
    Last Post: 01-22-2019, 01:24 PM
  2. Transfer & confirm data transfer between workbooks
    By fenfool in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2015, 01:10 PM
  3. Declaring workbooks for different modules
    By Borg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2012, 09:33 PM
  4. How to transfer modules from one spreadsheet to another with VB
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2010, 09:01 AM
  5. Rogue modules & data transfer problems
    By DavidMG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2007, 04:18 PM
  6. Exporting/Importing modules between two workbooks
    By AnnieLilly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2007, 09:08 PM
  7. [SOLVED] Importing Modules From Other Workbooks
    By Jim Jackson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2006, 03:00 PM

Tags for this Thread

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