Thread: Is it possible to copy vba macros into a workbook using a vba macroto do the copying
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Desmond Walsh Desmond Walsh is offline
external usenet poster
  
Posts: 28
Default Is it possible to copy vba macros into a workbook using a vbamacro to do the copying
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
Reply With QuoteReply With Quote