I need a single source code workbook for multiple files to reference, but they need to pass the user's input, which is an integer, string, and an array. I understand that the code to execute a code from another workbook is this:
Application.Run "Book1.xlsm!Macro"
And that this option to pass parameters to a sub routine:
'Both of these statements call a Sub
Call Procdure1 (FirstArgument, SecondArgument)
Procedure1 FirstArgument, SecondArgument
I can't figure how to combine these two to make them work. How do I pass parameters to a sub routine in a different workbook?
Bookmarks