Hi guys, I know very little about VBA; I have just put together some code bits based mostly on what I see in this forum
There is a manual process I'd like to automate. Instead of the user manually importing an external file into a table, I want a function to grab the most recent file in a particular directory. Is that possible?
For example, I have a table called Input, and I want to append the file I just saved on my network, which in this case is G:\Files\2014\TA_140928_011007.txt. The two ways to know which file to use is that the date is part of the filename (TA_YYMMDD_999999.txt), and also the Date Modified attribute.
I am aware that if the user needs to work the files out of date order, he/she cannot use this code.
Thanks in advance!
cheezfri
There is a manual process I'd like to automate. Instead of the user manually importing an external file into a table, I want a function to grab the most recent file in a particular directory. Is that possible?
For example, I have a table called Input, and I want to append the file I just saved on my network, which in this case is G:\Files\2014\TA_140928_011007.txt. The two ways to know which file to use is that the date is part of the filename (TA_YYMMDD_999999.txt), and also the Date Modified attribute.
I am aware that if the user needs to work the files out of date order, he/she cannot use this code.
Thanks in advance!
cheezfri