Prev: declaration help please
Next: Calling one UDF from another in a different module
From: Prof Wonmug on 27 Apr 2010 18:46
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: ryguy7272 on 27 Apr 2010 19:53
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.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Prof Wonmug" wrote:

> 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 28 Apr 2010 08:27
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 scanned the FAQ and the function list and tried a search. I didn't
see anything that worked on all workbooks. There were lots of things
that worked on all worksheets and maybe all open workbooks, but not
all workbooks.
From: Peter T on 28 Apr 2010 11:59
Try Find, FindAll with "myFunc("

Ensure Match Entire cell is not checked and Look in: Formulas

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 28 Apr 2010 13:39
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?
>
 |  Next  |  Last
Pages: 1 2
Prev: declaration help please
Next: Calling one UDF from another in a different module