Running a Macro on external non-macro enabled workbook

[rudolfweyers]

Good day

I currently have 2 workbooks where workbook A pulls info from workbook B. I need to run a macro on workbook B to convert info on there in order for it to be usable. The info on workbook B gets generated externally, so every time it deletes the workbook and creates a new one, therefore permanently enabling macros won't work.

So I would like to have a way where either of the following options would work
1. Open workbook A, which can be macro enabled, and have it run a macro on workbook B automatically
2. Open workbook A, open workbook B automatically, and run the macro from within A on B

Is this possible?

 

[RoryA]

Yes it is. A macro in one workbook can manipulate another workbook. If you need it to run automatically when workbook A opens, either call the macro auto_open and put it in a normal module in workbook A, or use the Workbook_Open event in the ThisWorkbook module of workbook A.

 

[rudolfweyers]

Yes it is. A macro in one workbook can manipulate another workbook. If you need it to run automatically when workbook A opens, either call the macro auto_open and put it in a normal module in workbook A, or use the Workbook_Open event in the ThisWorkbook module of workbook A.

Thanks, I will go have a look if I can figure it out. I'm very new to writing macros