Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default insert a macro into a workbook using vba

I have a macro, m1, that is run from an add-in menu. I would like m1 to
insert a macro, m2, into a blank workbook, b1.xls, so that m2 is part of the
file b1.xls.

Is this possible?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default insert a macro into a workbook using vba

see Chip Pearson's page on this

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy


"mcphc" wrote:

I have a macro, m1, that is run from an add-in menu. I would like m1 to
insert a macro, m2, into a blank workbook, b1.xls, so that m2 is part of the
file b1.xls.

Is this possible?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default insert a macro into a workbook using vba

Create a template workbook with m2 in it, and create the workbook from the
template.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"mcphc" wrote in message
...
I have a macro, m1, that is run from an add-in menu. I would like m1 to
insert a macro, m2, into a blank workbook, b1.xls, so that m2 is part of
the
file b1.xls.

Is this possible?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to insert copy and insert formulas only to next blank row bob Excel Programming 0 June 30th 06 12:02 PM
Macro or OLE method to insert worksheet from template workbook Lyndon Rickards Excel Discussion (Misc queries) 0 January 30th 06 08:46 PM
Need macro to insert workbook into another workbook using input box newnhamm Excel Programming 2 December 15th 05 07:34 PM
Insert VBA code with a macro in a .xls file by workbook open event mihai[_3_] Excel Programming 8 July 29th 04 01:49 PM
insert macro in new workbook Douvid[_2_] Excel Programming 1 July 29th 03 04:19 PM


All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"