Hello

I'm a newbie when it comes to VBA programming but I managed to find bits of code that I've merged together in a script based on info I found from different sources online. I just need a little help tweaking the code so it works for my purposes. Here's what I'd like to accomplish:
  1. Run macro when Excel file is opened
  2. Search inside a specific folder for all text files
  3. Copy all data from text files into same worksheet
  4. Remove duplicate rows that occur from scanning text files multiple times

Here is the code I have found so far, but it needs some tweaking:

Please Login or Register  to view this content.

Any help/guidance is greatly appreciated!
Thank you,
Anthony