Executing macro from same workbook is a routine task in Excel automation. Many a times, We face a situation where we need to a call macro from another workbook. Sometimes, it's very useful to call a macro from another workbook which will help us optimize macro code. Also, it is very easy to modify the code in individual macro of separate workbook.
Taking consideration of these advantage of macro with separate workbook will be used to automate tasks which scheduled on specific time intervals.
Taking consideration of these advantage of macro with separate workbook will be used to automate tasks which scheduled on specific time intervals.
