Thread: Execute code from book1 of code from book2
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Execute code from book1 of code from book2
You can use Application.Run.

Application.Run "Book2.xls!ProcedureName"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

"Rick" wrote in message
...
Is there a way of executing code that is in book2 from book1 via VB Code?



Reply With QuoteReply With Quote