Thread: VBA modules
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
arunkhemlai arunkhemlai is offline
external usenet poster
 
Posts: 16
Default 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?