How to run a macro on closed workbook with no macro on it

%3CLINGO-SUB%20id%3D%22lingo-sub-1639613%22%20slang%3D%22en-US%22%3EHow%20to%20run%20a%20macro%20on%20closed%20workbook%20with%20no%20macro%20on%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1639613%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20one%20workbook%20and%20I%20have%20load%20data%20into%20it%20using%20an%20ETL%20tool%20but%20loading%20data%20into%20macro%20enabled%20sheet%20is%20taking%20huge%20time%20so%20we%20are%20planning%20to%20pull%20out%20the%20macros%20and%20load%20data%20into%20normal%20excel%20sheet%20and%20then%20run%20macros%20on%20it%20from%20outside%20without%20opening%20it.%20Is%20it%20possible%20to%20achieve%20it%3F%20if%20so%20how%20can%20I%20do%20it%20%3F%20Basically%20I%20will%20have%20one%20sheet%20with%20huge%20amount%20of%20data%20cannot%20open%20due%20to%20large%20size%2C%20so%20I%20have%20run%20a%20macro%20on%20it%20from%20another%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1639613%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

I have one workbook and I have load data into it using an ETL tool but loading data into macro enabled sheet is taking huge time so we are planning to pull out the macros and load data into normal excel sheet and then run macros on it from outside without opening it. Is it possible to achieve it? if so how can I do it ? Basically I will have one sheet with huge amount of data cannot open due to large size, so I have run a macro on it from another worksheet.

 

Thanks in advance.

0 Replies