ChuckDrago
Active Member
- Joined
- Sep 7, 2007
- Messages
- 470
- Office Version
- 2010
- Platform
- Windows
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
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