Dr. Demento
Well-known Member
- Joined
- Nov 2, 2010
- Messages
- 618
- Office Version
- 2019
- 2016
- Platform
- Windows
So I do a report where I "download" a number of text files but I do not save them. My goal is to loop thru all open text files, copy the contents, and based on the filename (which I would have to assign to a temp variable), paste it to a specific location, and then close the file. Except, I'm clueless on how to loop thru something outside of Excel.
Thoughts?
Thanks y'all.
Thoughts?
Thanks y'all.