calling external VBA sub with parameters

[JamieArvato]

hi

how do i call a sub-procedure with parameters that exists in another file, i.e.:

in Book1.xls, i have:

sub MyProc (my_string as String)
....
end sub

how do i call this from book2.xls?

TIA

jamie

 

[TonyJollans]

Hi Jamie,

This should do it ..

[blue]Application.Run "Book1.xls!MyProc", "My String"[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.