| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Hybrid Mode
