Excel VBA - Searching for code across multiple workbooks/projects

  • Thread starter Thread starter kazzy
  • Start date Start date
K

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?
 
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?
Click to expand...

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 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
Click to expand...

Hi Garry, Thanks for the advice.

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

:-)
 
Back
Top