We have some third party software that we use at our company to pull
financial data from their database. They are using an xll add-in and
they also have a few .dll files in the install directory. I can't see
any of the code or even how they are calling it by recording a macro
but I notice that if their add-in is enabled, it automatically adds
over 2000 defined names to the workbook. They cannot be seen using
the standard name view but to manage names I use the incredibly handy
Name Manager 4.0 utility (developed by Jan Karel Pieterse in
collaboration with Decision Models,UK). The problem with the names is
that the utility reads all of them so it takes much longer to work
with it and more importantly it adds about 200kbp to every file even
if the file is not using any of the third party functions/formulas.
Does anyone have any ideas as to how I can get rid of all these names
automatically (aside from manually doing it with the name manager
utility)?

Thanks