#1
|
||||
|
||||
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 |
#2
|
||||
|
||||
In the future please post in the correct forum. I moved it for you this time
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
Quote:
For that matter, what makes this the "correct" forum? |
#4
|
||||
|
||||
As this question is about UDF, it is related to VBA, thus "Excel programming" seems the best choice.
Posting in the right "sub" forum increases your chances of getting an answer. Obviously, your problem cannot be solved by formulas, does it? Of course if you insist I can move it to another sub forum of your choice.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
Quote:
The forum name is "Excel Programming", is it? A couple of remarks: You say you use 2 different OS and Office. And Excel workbooks are all in your hard disk. Do you have 2 OS installed on same computer, or do you work with 2 different computers? Anyone who is offering some help does need to know this! Maybe you must spend some of your time to organize things better in future (having hundreds of workbooks to follow is an incentive enough). a) Create a folder. For every function you'll have a Excel workbook with this function (really you create and edit your function there). Additionally you have a sheet with list of workbooks (and maybe links too), where the function is used; b) (The approach I'm myself using.) Have a folder on network drive mapped for all users. For every Excel (or other) application, you have a subfolder (this may be leveled subfolders system) for every application. You have full rights for whole folder, all others have read-only rights. Every application is named like ApplicationName_v###.xlsm. The folder has subfolder Archive (and may have a subfolder Dev, but you can keep development elsewhere when you want. In main subfolder, a latest version of application is stored, and other files needed by user like registry editors. Whenever a new version is added into main subfolder, the old version is moved into Archive subfolder. And it is good to have a workbook with list of users of application in subfolder Dev, or where ever you are design the application. Whenever you put a new version of application on main subform, you have to give a message for all affected users to get a new version of application, and users are replacing their old version with new one. Of-course this setup will not work when users are entering their own data into their workbooks (my applications mostly read data from 3rd-party applications and dispaly the recieved information e.g. graghically, or they work as converters - they read data from file in certain format (*txt, *.csv, *.xls, etc. - any format Excel can read) and write the recieved information to file in another format making various calculations between) - then you have to open user's old version, an update all changes manually from your new version workbook |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Search function | jarodshelly | Word | 3 | 04-02-2013 08:19 PM |
Data table search function | omtinole | Excel Programming | 1 | 07-13-2012 10:03 PM |
Search Function | Rick203 | Outlook | 1 | 08-29-2011 11:23 PM |
Search Function Problem | MageWind | Excel | 2 | 06-29-2011 09:46 AM |