Code to rewrite existing code

[Maagaard]

Hi,

I have a series of workbooks, where I need to find an excisting macro and rewrite it.

Is this possible and how can I do it?

Thank you in advance!

Maagaard

 

[XLfriend777]

Hi Maagaard - To find an existing macro, simply open all workbooks that have the .xlsm extension. Those are the ones that can contain macros. Then press Alt + F11 to open the VBA editor. The macros will be listed. Once you find the macro, we can work on the rewrite as necessary.

Hope this helps.

Happy Excelling,

goesr

 

[Maagaard]

Hi Maagaard - To find an existing macro, simply open all workbooks that have the .xlsm extension. Those are the ones that can contain macros. Then press Alt + F11 to open the VBA editor. The macros will be listed. Once you find the macro, we can work on the rewrite as necessary.

Hope this helps.

Happy Excelling,

goesr

Thanks for your reply! However, I think you misunderstood me. What I need is to write a macro, that can find a specific sub in another workbook and rewrite it.

Part of my job is to keep different macros updated, and my predecessor wrote some code that gets "confused" about dates, when a new year starts. This macro is copied around 60 times into different versions. So instead of me manually changing the code, I want to write a code that can go through all xlsm files and rewrite it. Is that even possible?