Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108737

Re: Is it possible to copy vba macros into a workbook using a vba macro to do the copying

Show all headers | View raw

You could put the macros in an XLAM (addin) that also loads a custom 
menu. This makes the current code always contained in a single 
(distributable) file, and obviates the need for your period files to 
contain any code at all. Just redistribute any new version of your 
addin as needed!

Normally, I'd 'tag' the project workbooks so the addin knows which 
files to make its menus available to. I use a template for the fiscal 
period file so a new one can be started in new fiscal periods.

So then...

  Addin:
    - contains all code/forms/features/functionality
    - creates/destroys its own custom menus at startup/shutdown
    - only enables menus when one of its project files is active

  Template:
    - reusable project file used by the addin for dedicated tasks
    - new template created by the addin for each new fiscal period

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Is it possible to copy vba macros into a workbook using a vba macro to do the copying Desmond Walsh <deasmhuinbreathnach@gmail.com> - 2016-04-10 10:02 -0700
  Re: Is it possible to copy vba macros into a workbook using a vba macro to do the copying GS <gs@v.invalid> - 2016-04-10 14:37 -0400
  Re: Is it possible to copy vba macros into a workbook using a vba macro to do the copying Desmond Walsh <deasmhuinbreathnach@gmail.com> - 2016-04-10 15:42 -0700
    Re: Is it possible to copy vba macros into a workbook using a vba macro to do the copying GS <gs@v.invalid> - 2016-04-11 09:38 -0400
      Re: Is it possible to copy vba macros into a workbook using a vba macro to do the copying Desmond Walsh <deasmhuinbreathnach@gmail.com> - 2016-04-11 13:01 -0700
        Re: Is it possible to copy vba macros into a workbook using a vba macro to do the copying GS <gs@v.invalid> - 2016-04-11 18:26 -0400
  Re: Is it possible to copy vba macros into a workbook using a vba macroto do the copying profilmuoitam18 <profilmuoitam18@gmail.com> - 2016-04-11 10:23 +0100

csiph-web