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