ExcelBanter - Modify a macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Modify a macro (https://www.excelbanter.com/excel-programming/349453-modify-macro.html)

Philippe Jacquet

Modify a macro

I have the same macro in 100 excel files .
I want to change the macro location (path) in each of this excel files .
I 'll save the new macro in the PERSO.xls

How can i with VBA change the location of the macro ?

Thanks

All times are GMT +1. The time now is 11:54 PM.