Calling a Subroutine from an external module

  • Thread starter Thread starter Fausto Arinos Barbuto
  • Start date Start date
F

Fausto Arinos Barbuto

Hi All;

I have two different Excel workbooks open, and each has a module
containing VBA subroutines. I want a subroutine from workbook "A"
to call a subroutine inside workbook "B". How could I do that?

Many thanks in advance,

---Fausto
 
Fausto,

Use Application.Run. E.g.,

Application.Run "Book2.xls!TheMacro"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top