Excel VBA - Searching for code across multiple workbooks/projects

[kazzy]

Hi VBAers,

I put some code in a workbook that I now want to re-use. My problem is
I cannot remember which workbook it's in & thus, it could be in one of
30 workbooks. I was wondering if anyone can suggest a better way to
find the code rather than searching for it 30 times please?

Also, I think best practice is that I put my favourite code into my
personal.xls file - is that correct?

 

[GS]

kazzy was thinking very hard :

Hi VBAers,

I put some code in a workbook that I now want to re-use. My problem is
I cannot remember which workbook it's in & thus, it could be in one of
30 workbooks. I was wondering if anyone can suggest a better way to
find the code rather than searching for it 30 times please?

Also, I think best practice is that I put my favourite code into my
personal.xls file - is that correct?

Using PERSONAL.XLS is one way to store reusable code. Another way is to
create an addin so the code is available to any workbook it might be
used with.

 

[kazzy]

kazzy was thinking very hard :




Using PERSONAL.XLS is one way to store reusable code. Another way is to
create an addin so the code is available to any workbook it might be
used with.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Hi Garry, Thanks for the advice.

Yet another VBA journey for me to learn about addins - how to create
& how users can install. Phew!