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:
- Run macro when Excel file is opened
- Search inside a specific folder for all text files
- Copy all data from text files into same worksheet
- 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:
Any help/guidance is greatly appreciated!
Thank you,
Anthony
Bookmarks