Is there a way in VBA to find a file name that has an unknown portion to it? Let me explain:
Our computer system is UNIX based. It is creating a text file for us that uses the date, the hour, minutes and seconds that the file was created as its file name. This file name looks exactly like this:
Finding the date isn't an issue. The unknown part is the date and time the file was created as the "file extension" (.104056) is the time stamp. That is the variable that I need to access.
Is there an "any extension" code such as "filePath = 20141210.(asterisk)" (or some other character) that would allow me to open this file?
In advance, thanks for your assistance.