My company extends Microsoft Excel by creating additional functions and templates. I would like to have an automated tool where it will automatically open ALL the functions/templates one at a time (there are quite a lot of them) and check if any of the cell contains #Values!.
Are there tools out there that will do the job? If not where can I start looking to create one myself?
Why not write a macro in Excel that does just that? Or, if you insist on a separate tool, write a macro that saves all sheets as .csv and then use another script that will scrub through the file for the string #value? Most scripting languages could do that in ten lines of code.
2. Web/HTTP (HTML mode)
7. Web 5800
Remote Access 1000
9. Windows Server 2003 SP1