I've misplaced a macro <g!
 

Somewhere among the 50 or so WBs that I have on the Flash drive at the
moment, there is a macro I wrote which uses a nice Select Case system to do
some dirty work. Now I wold like to get back to it so I can hack it for a new
job rather than reinventing that particular wheel.

I tried doing a reqular Windows Search for files with ".xls" in their name
and for "Select Case" as content. Didn't find a one.

I'll bet there is a way (Excel 2003, BTW). Hayullpppp!
--
Dave
Temping with Staffmark
in Rock Hill, SC

I've misplaced a macro <g!
 

Nope, you won't find it by looking in .xls for content. You will need to
look in VBA but I am not sure what the method is for that. If you can get
Chip Pearson or Tom Olgivy to respond, they can probably get you going.
Otherwise, it is open each file and do a find in the VBA module.

"Dave Birley" wrote:

Somewhere among the 50 or so WBs that I have on the Flash drive at the
moment, there is a macro I wrote which uses a nice Select Case system to do
some dirty work. Now I wold like to get back to it so I can hack it for a new
job rather than reinventing that particular wheel.

I tried doing a reqular Windows Search for files with ".xls" in their name
and for "Select Case" as content. Didn't find a one.

I'll bet there is a way (Excel 2003, BTW). Hayullpppp!
--
Dave
Temping with Staffmark
in Rock Hill, SC

I've misplaced a macro <g!
 

Dave

I have never had any luck finding text in *.xls files using the Windows search.

Agent Ransack never fails me.

http://www.mythicsoft.com/agentransack/

Freeware and easy to install and use.


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 11:56:00 -0700, Dave Birley
wrote:

Somewhere among the 50 or so WBs that I have on the Flash drive at the
moment, there is a macro I wrote which uses a nice Select Case system to do
some dirty work. Now I wold like to get back to it so I can hack it for a new
job rather than reinventing that particular wheel.

I tried doing a reqular Windows Search for files with ".xls" in their name
and for "Select Case" as content. Didn't find a one.

I'll bet there is a way (Excel 2003, BTW). Hayullpppp!