A colleague suggested that FileLocatorPro can search inside cells in Excel to locate function calls. Can you tell me if this is true?
I have written a large number of custom functions 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.
If FLP can do this, please let me know if there is anything I need to know to make it work.
I am using Office 2007 on Windows XP and Office 2016 on Windows 10.