View Single Post
 
Old 06-30-2018, 03:19 PM
Jennifer Murphy's Avatar
Jennifer Murphy Jennifer Murphy is offline Windows XP Office 2007
Competent Performer
 
Join Date: Aug 2011
Location: Silicon Valley
Posts: 234
Jennifer Murphy is on a distinguished road
Default Is there a way to search all workbooks for speciic function calls?

I have written a large number of custom functions (UDFs) that are used in hundreds of workbooks scattered all over my hard disk. From time to time, I have the need to enhance one of these functions requiring a change in syntax. I would like to be able to locate all workbooks that make use of this function so I can ensure that they continue to work properly.

I have tried every way I can think of with the Windows search facility to do this without success.

I am using Office 2007 on Windows XP and Office 2016 on Windows 10.

Thanks
Reply With Quote