I have .txt files saved as their date in yyyymmdd.txt format. I need to be able to open these files based on today's date or a cell value and use the info to paste into an existing excel file. I can handle the pasting of the info but do not know how to open files based on this criteria. Any help would be appreciated
cwiggins 0 Newbie Poster
vb5prgrmr 143 Posting Virtuoso
Couple of ways but the easiest would be...
FileToOpen = Format(Now, "yyyymmdd") & ".txt"Good Luck
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.