PC Review


Reply
Thread Tools Rate Thread

Combine two macros into one

 
 
Shirley
Guest
Posts: n/a
 
      10th Jan 2008
Hi,

I'm using Word 2003. I have two macros that I want to combine into one (add
2nd after the 1st).

I'm a complete novice in the VBA editor. If you can pls. tell me the
specific wording to copy from 2nd macro (do I take the entire thing?) and
where exactly to place at after the 1st macro (END WITH?) so it runs
seamlessly, I would truly appreciate it.

Thanks,
Shirley
 
Reply With Quote
 
 
 
 
Beth Melton
Guest
Posts: n/a
 
      10th Jan 2008
If you want to run Macro 2 after Macro 1 then at the end of Macro 1, insert
a blank line if necessary before Exit Sub, and type:

Call <MacroName>

Where <MacroName> is the name of Macro 2.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/boo...x#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

"Shirley" <(E-Mail Removed)> wrote in message
news:C7344416-656B-4D70-8F39-(E-Mail Removed)...
> Hi,
>
> I'm using Word 2003. I have two macros that I want to combine into one
> (add
> 2nd after the 1st).
>
> I'm a complete novice in the VBA editor. If you can pls. tell me the
> specific wording to copy from 2nd macro (do I take the entire thing?) and
> where exactly to place at after the 1st macro (END WITH?) so it runs
> seamlessly, I would truly appreciate it.
>
> Thanks,
> Shirley



 
Reply With Quote
 
Shirley
Guest
Posts: n/a
 
      24th Jan 2008
Thank you so much. I know it's simple to you pros, but I just couldn't
figure it out. This info was so useful - thanks!

Regards,
Shirley

"Beth Melton" wrote:

> If you want to run Macro 2 after Macro 1 then at the end of Macro 1, insert
> a blank line if necessary before Exit Sub, and type:
>
> Call <MacroName>
>
> Where <MacroName> is the name of Macro 2.
>
> Please post all follow-up questions to the newsgroup. Requests for
> assistance by email cannot be acknowledged.
>
> ~~~~~~~~~~~~~~~
> Beth Melton
> Microsoft Office MVP
>
> Coauthor of Word 2007 Inside Out:
> http://www.microsoft.com/MSPress/boo...x#AboutTheBook
>
> Word FAQ: http://mvps.org/word
> TechTrax eZine: http://mousetrax.com/techtrax/
> MVP FAQ site: http://mvps.org/
>
> "Shirley" <(E-Mail Removed)> wrote in message
> news:C7344416-656B-4D70-8F39-(E-Mail Removed)...
> > Hi,
> >
> > I'm using Word 2003. I have two macros that I want to combine into one
> > (add
> > 2nd after the 1st).
> >
> > I'm a complete novice in the VBA editor. If you can pls. tell me the
> > specific wording to copy from 2nd macro (do I take the entire thing?) and
> > where exactly to place at after the 1st macro (END WITH?) so it runs
> > seamlessly, I would truly appreciate it.
> >
> > Thanks,
> > Shirley

>
>
>

 
Reply With Quote
 
Beth Melton
Guest
Posts: n/a
 
      27th Jan 2008
You're welcome. :-)

Always remember, those who know how to do something learn at some point. Now
it's simple for you too. ;-)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/boo...x#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

"Shirley" <(E-Mail Removed)> wrote in message
news:8DCE1965-2AE9-4DB5-8D7D-(E-Mail Removed)...
> Thank you so much. I know it's simple to you pros, but I just couldn't
> figure it out. This info was so useful - thanks!
>
> Regards,
> Shirley
>
> "Beth Melton" wrote:
>
>> If you want to run Macro 2 after Macro 1 then at the end of Macro 1,
>> insert
>> a blank line if necessary before Exit Sub, and type:
>>
>> Call <MacroName>
>>
>> Where <MacroName> is the name of Macro 2.
>>
>> Please post all follow-up questions to the newsgroup. Requests for
>> assistance by email cannot be acknowledged.
>>
>> ~~~~~~~~~~~~~~~
>> Beth Melton
>> Microsoft Office MVP
>>
>> Coauthor of Word 2007 Inside Out:
>> http://www.microsoft.com/MSPress/boo...x#AboutTheBook
>>
>> Word FAQ: http://mvps.org/word
>> TechTrax eZine: http://mousetrax.com/techtrax/
>> MVP FAQ site: http://mvps.org/
>>
>> "Shirley" <(E-Mail Removed)> wrote in message
>> news:C7344416-656B-4D70-8F39-(E-Mail Removed)...
>> > Hi,
>> >
>> > I'm using Word 2003. I have two macros that I want to combine into one
>> > (add
>> > 2nd after the 1st).
>> >
>> > I'm a complete novice in the VBA editor. If you can pls. tell me the
>> > specific wording to copy from 2nd macro (do I take the entire thing?)
>> > and
>> > where exactly to place at after the 1st macro (END WITH?) so it runs
>> > seamlessly, I would truly appreciate it.
>> >
>> > Thanks,
>> > Shirley

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
combine two macros puiuluipui Microsoft Excel Misc 8 21st May 2009 10:30 AM
combine two macros puiuluipui Microsoft Excel Misc 0 20th May 2009 10:14 AM
Combine several macros Vijay Kotian Microsoft Excel Programming 8 24th Jan 2008 04:14 PM
COMBINE TWO MACROS INTO ONE K Microsoft Excel Programming 10 4th Jan 2008 01:48 PM
Combine 2 macros into 1 Please. =?Utf-8?B?U3RldmVk?= Microsoft Excel Programming 1 24th May 2007 06:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:31 PM.