+ Reply to Thread
Results 1 to 3 of 3

Easy Method to update the revised VBA modules in Excel 2013

  1. #1
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Unhappy Easy Method to update the revised VBA modules in Excel 2013

    Hello All,
    I have created an VBA enabled template to automate few things which is being used by nearly 40 people everyday.Also this template has few data in it always.
    I keep revising this the VBA codes every now and then (Based on suggestions received) and then send the revised template to all 40 people. In turn, these 40 people copy their existing data from old to new template which takes some time.

    I actually want to know, is there any better way to update these revised modules to all 40 users in one shot..? I mean, some patches kind of a thing.?
    Instead sending revised template verytime, i can send these patches and ask them to update it. By this, all user don't have to move their data.

    I hope i am clear with my concern.

    Please help and provide me Step by step process to do this.

    Thanks,
    Madvesh

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Easy Method to update the revised VBA modules in Excel 2013

    No, not really. One possible approach is to create your code as an add-in and just get the users to install the newer version of it.

    A more complex idea is one that Bruce McPhearson came up with on his Excel Ramblings blog - he uses github to host his code then adds code to the workbook to pull this down, this is somewhat more advanced though

  3. #3
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Re: Easy Method to update the revised VBA modules in Excel 2013

    Can you please explain detailed steps to create add-in..? and how i can make use of this to fix my issue?

+ 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. Macro not working after update to excel 2013
    By eskodero in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2014, 11:30 AM
  2. Excel 2013 - Macro to update new sheet
    By quabba in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2014, 11:53 AM
  3. Help with Auto Filter in Excel 2013 - Autofilter method of Range class failed
    By yus786 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2014, 03:25 PM
  4. Method to define a variable across multiple Modules?
    By texas32 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2013, 04:57 PM
  5. Format excel to revised date automatically when revised
    By annetteberrios in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2005, 10:05 AM

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