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

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/

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

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