I am trying to invoke a set of common macros that need to be executed after importing the data from excel sheet into a data model using another Macro. Any help would be greatly appreciated!
If you are looking to just run macro B from macro A, you can use the MacroRun command - you can pass parameters to the second macro as well:
MacroRun MacroDir & "\Macro B.bas", myParameter
@spfister ... Thanks for the suggestions. I implemented MacroRun command for my use case and it worked perfectly ! :)
Powered by IDERA