ExcelBanter - VBA modules

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

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

- - VBA modules (https://www.excelbanter.com/excel-programming/327035-vba-modules.html)

Neugierig

VBA modules

I have a standard vb module in many excel files.
How can i find it automatically in all the files i have cause i must
replace it with a new one?

arunkhemlai

VBA modules

Create a Personal.xls file that stores a macro that does find/replace (using
VBE object).

Search on google.com with keyword "Personal.xls" and "VBE object"; therea
lot of examples out there.

HTH -- arunkhemlai

"Neugierig" wrote:

I have a standard vb module in many excel files.
How can i find it automatically in all the files i have cause i must
replace it with a new one?

All times are GMT +1. The time now is 07:08 AM.