KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I would like to know if there is a way to call a VBA function or method from another specified workbook's module as it is possible for a specific worksheet without using the Application.Run For the worksheet I can call for example : ActiveSheet.MyTest() if MyTest is defined in the sheet module But I would like to call a function which is defined in a module I tried : ActiveWorkbook.MyTestModule() ActiveWorkbook.VBProject.VBComponents("MyModule").MyTestModule(myArg) which don't work generating an error Object does not support this method I could call Application.Run(ActiveWorkbook.name & "!MyTestModule", myArg) But I am not sure of the error handling of the Application.Run and I would find cleaner to run directly the method
Tags (comma-separated)
Save Edits
Cancel