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


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

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

From GS <gs@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Is it possible to copy vba macros into a workbook using a vba macro to do the copying
Date 2016-04-11 18:26 -0400
Organization A noiseless patient Spider
Message-ID <neh84m$d1f$1@dont-email.me> (permalink)
References <9975dded-e054-4512-b2ce-50560442704a@googlegroups.com> <16e14a4c-0305-4296-a091-0a37572876fa@googlegroups.com> <neg96k$bcq$1@dont-email.me> <59ab2142-27c9-44f3-8d6e-6a22dc07581c@googlegroups.com>

Show all headers | View raw


> On Monday, April 11, 2016 at 9:38:40 AM UTC-4, GS wrote:
>> This will copy the entire module, resulting in duplicate procedure 
>> names if you don't remove the existing module first. Not to mention 
>> having to do maintenance on every workbook, wouldn't it be easier 
>> (and  more productive/efficient) to maintain 1 addin?
>> 
>> -- 
>> Garry
>> 
>> Free usenet access at http://www.eternal-september.org
>> Classic VB Users Regroup!
>>   comp.lang.basic.visual.misc
>>   microsoft.public.vb.general.discussion
>
> Yes, your point is very valid. I will look into the addin technique 
> that you suggested and report if I have any difficulty. Thank you for 
> taking the time to reply
>
> Desmond 

If you do a lot of this sort of work, addins would be of great benefit. 
For reference material you could check out the following books...

  http://www.appspro.com/Books/Books.htm

-- 
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 | NextPrevious 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