Editing a macro which is within another macro.
 

When I am running macro1, how can I call on macro2 to edit it in order
to replace all instances of "abc" with "xyz" before continuing on and
execute macro2? Thanks for your help.

Tom

Editing a macro which is within another macro.
 

Tom

If xyz is a variable you might just change its value to something else while
calling the second macro. For example:

Sub Macro1()
Dim abc As String
abc = "Hello world!"
Call Macro2(abc)
End Sub

Sub Macro2(ByVal xyz As String)
MsgBox xyz
End Sub

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/

Editing a macro which is within another macro.
 

On May 5, 6:40*pm, Robert Martim, Excel wrote:
Tom

If xyz is a variable you might just change its value to something else while
calling the secondmacro. For example:

Sub Macro1()
* Dim abc * As String
* abc = "Hello world!"
* Call Macro2(abc)
End Sub

Sub Macro2(ByVal xyz As String)
* MsgBox xyz
End Sub

--
Best regards
Robert, Excel MVP
* Author of RibbonX: Customizing the Office 2007 Ribbon:
* Find me athttp://www.msofficegurus.com- be part of it!
* FORUM:http://www.msofficegurus.com/forum/

Thanks Robert. That was great.

Regards,
Tom

Editing a macro which is within another macro.
 

On May 5, 6:40*pm, Robert Martim, Excel wrote:
Tom

If xyz is a variable you might just change its value to something else while
calling the second macro. For example:

Sub Macro1()
* Dim abc * As String
* abc = "Hello world!"
* Call Macro2(abc)
End Sub

Sub Macro2(ByVal xyz As String)
* MsgBox xyz
End Sub

--
Best regards
Robert, Excel MVP
* Author of RibbonX: Customizing the Office 2007 Ribbon:
* Find me athttp://www.msofficegurus.com- be part of it!
* FORUM:http://www.msofficegurus.com/forum/

However, there was a snag. I should have made it clearer.
Macro1 resides in File1.xls while Macro2 resides in File2.xls
and "abc" and "xyz" are both strings in Macro2. So, what do I
have to modify? Thanks.

Tom