Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-30-2018, 03:19 PM
Jennifer Murphy's Avatar
Jennifer Murphy Jennifer Murphy is offline Is there a way to search all workbooks for speciic function calls? Windows XP Is there a way to search all workbooks for speciic function calls? Office 2007
Competent Performer
Is there a way to search all workbooks for speciic function calls?
 
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
  #2  
Old 07-01-2018, 12:07 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Is there a way to search all workbooks for speciic function calls? Windows 7 64bit Is there a way to search all workbooks for speciic function calls? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 07-01-2018, 01:22 AM
Jennifer Murphy's Avatar
Jennifer Murphy Jennifer Murphy is offline Is there a way to search all workbooks for speciic function calls? Windows XP Is there a way to search all workbooks for speciic function calls? Office 2007
Competent Performer
Is there a way to search all workbooks for speciic function calls?
 
Join Date: Aug 2011
Location: Silicon Valley
Posts: 234
Jennifer Murphy is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
In the future please post in the correct forum. I moved it for you this time
And just how was I supposed to know which is the "correct" forum?

For that matter, what makes this the "correct" forum?
Reply With Quote
  #4  
Old 07-01-2018, 03:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Is there a way to search all workbooks for speciic function calls? Windows 7 64bit Is there a way to search all workbooks for speciic function calls? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #5  
Old 07-01-2018, 03:55 AM
ArviLaanemets ArviLaanemets is offline Is there a way to search all workbooks for speciic function calls? Windows 8 Is there a way to search all workbooks for speciic function calls? Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by Jennifer Murphy View Post
And just how was I supposed to know which is the "correct" forum?
As obviously there is not any windows search feature or Excel built-in function doing what you want, the only real way is a vba code (a function returning a path and file name of #th workbook having a string "YourUDFName(" in any of worksheets, or a procedure creating a list of such workbooks in some destination sheet)

Quote:
Originally Posted by Jennifer Murphy View Post
For that matter, what makes this the "correct" forum?
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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search function jarodshelly Word 3 04-02-2013 08:19 PM
Is there a way to search all workbooks for speciic function calls? Data table search function omtinole Excel Programming 1 07-13-2012 10:03 PM
Is there a way to search all workbooks for speciic function calls? Search Function Rick203 Outlook 1 08-29-2011 11:23 PM
Search Function Problem MageWind Excel 2 06-29-2011 09:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft