View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David Jessop David Jessop is offline
external usenet poster
 
Posts: 3
Default A simple question

Try

Sub Test()
Application.Run "B!Module1.Test"
End Sub

where you've defined a function called Test in Module1 of worksheet B.

HTH

"Fausto Arinos Barbuto" wrote:


Hi,

I have two workbooks, "A" and "B", and both are open and contain
macros/functions. How do I call (execute), from "A", a macro in "B"?
Is that possible?

Thanks in advance for any help!

---Fausto