Prev: declaration help please
Next: Calling one UDF from another in a different module
From: Peter T on 28 Apr 2010 13:58
No problem to process all open workbooks, but for sure it/they need to be
open

For each wb in application.workbooks
For each ws in wb.worksheets
etc

Regards,
Peter T

"Prof Wonmug" <wonmug(a)e.mcc> wrote in message
news:tjsgt512m5m66l69milm3sbbogg58et70r(a)4ax.com...
> On Wed, 28 Apr 2010 16:59:47 +0100, "Peter T" <peter_t(a)discussions>
> wrote:
>
>>Try Find, FindAll with "myFunc("
>>
>>Ensure Match Entire cell is not checked and Look in: Formulas
>
> I am able to get it to work within a workbook. I was hoping for a
> solution that would check all workbooks, whether open or not.
>
> Sounds like I'd need a macro or something.
>
>>Could write a macro to return a list of all found in each sheet. You would
>>need to open the workbook though.
>>
>>Regards,
>>Peter T
>>
>>"Prof Wonmug" <wonmug(a)e.mcc> wrote in message
>>news:75qet515fp9t8rp736r3am3muahebr1vs8(a)4ax.com...
>>> I've decided to make a few "improvements" to some of the UDFs in my
>>> personal add-in module. Now I need to find all of the calls to those
>>> UDFs in all of my workbooks, because the syntax has changed some.
>>>
>>> Is there an easy way to find them other than opening each one?
>>


From: Prof Wonmug on 29 Apr 2010 13:00
On Tue, 27 Apr 2010 16:53:02 -0700, ryguy7272
<ryguy7272(a)discussions.microsoft.com> wrote:

>I vaguely recall dealing with this before, but I can't remember if it was
>code or an add in. I think this will do it for you:
>http://www.asap-utilities.com/download-asap-utilities.php
>
>NYC public library is closing and they're ushering me out, so I can't test
>it now, but give it a whirl and see how you get along.

I sent them an email asking if asap can do this. They said it cannot,
but suggested this one:

For now you can also use the following add-in. It should do exactly
what you want and you can download a fully functional 15 day trail:

http://www.ablebits.com/excel-find-replace-manager-addins/

I haven't had a chance to try it yet.
First  |  Prev  | 
Pages: 1 2
Prev: declaration help please
Next: Calling one UDF from another in a different module