Names bloating

[ChuckDrago]

Hi everyone,

I developed an app which uses external text data, parsing it into Excel and manipulating it within for later saving the outcome. The macro portion that reads, formats and parses the text data into Excel is the result of my having used the recorder. It works very well but unfortunately, as the users parses and saves more files then both, the Names Manager and the Workbook Connections adds more line items related to the input files. I am sure this is not healthy down the road. Is there a way, code, snippet, whatever that either eliminates the name and connection used in that session? Massive clean ups are obviously not desirable because the undesired names comingle with legit named variables used within the code. I will really, really appreciate a tip here.
Thank you all!
Chuck

 

[Yongle]

NAMES
Deleting names is usually staightforward if we know either which names to retain or which names to delete

Is there a definitive list of names that can be provided to VBA so that VBA can be told to delete all other names every time the workbook is either closed or opened?