| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to copy vba macros into a workbook using a vba macro 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 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macroto delete extra space in a cell | Excel Programming | |||
| Copying macros to another workbook | Excel Discussion (Misc queries) | |||
| Use VBA to copy macros from one workbook to another | Excel Programming | |||
| Copy workbook without Macros | Excel Programming | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
![GS[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
