| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execute code from book1 of code from book2
Is there a way of executing code that is in book2 from book1 via VB Code?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Execute code from book1 of code from book2
application.Run "Book2.xls!MyMacro"
-- Regards, Tom Ogilvy "Rick" wrote: Is there a way of executing code that is in book2 from book1 via VB Code? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Execute code from book1 of code from book2
Application.Run "Book2.xls!module1.MyMacro"
"Rick" wrote: Is there a way of executing code that is in book2 from book1 via VB Code? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Execute code from book1 of code from book2
Thanks for the help
"vbapro" wrote: Application.Run "Book2.xls!module1.MyMacro" "Rick" wrote: Is there a way of executing code that is in book2 from book1 via VB Code? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA - Testing for Book1, Book2 etc. | Excel Discussion (Misc queries) | |||
| Book1 and Book2 | Excel Discussion (Misc queries) | |||
| =SUMIF(book2!L3:AF3, "=book1!O30", book2!L20:AF20) | Excel Discussion (Misc queries) | |||
| run macro in book1 from book2 - how? | Excel Programming | |||
| IE to Book1, to book2, then close Book1.xls | Excel Programming | |||
Linear Mode
