pass it/them using the arguments for the sub in workbookB.

Public SubInB(A, B)
msgbox A & " - " & B
End Sub

in workbookA

Sub Test1()
C = ThisWorkbook.Name
D = 10000
Application.run "WorkbooksB.xls!SubInB", C, D
End Sub

--
Regards,
Tom Ogilvy


Rees Macleod wrote in message
...

Hi Brian,

Thanks for the reply. What I mean is actually passing a variable from
VBA. In other words, I want to pass say, variable1 and variable2 from a
Sub running in workbookA.xls to another Sub waiting in workbookB.xls, so
I can continue working with variable1 and variable2's values that were
established in workbookA.xls


Thanks again,

Rees


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!