Hi guys
Is there any way to retrieve a file name from a given location using vba in access?
I receive a file daily onto our server which always has a different filename (this can't be changed as it comes from a 3rd party's automated system). I need to run some script against it but I want to do it automatically in the early hours of the morning.
Presently, the script is run manually which means that I have to open up the module and change the filename in the code. What I want to do is for the code to look in the relevant folder, get the filename, use this to open and process the data then move the file to a 'done' folder. I know how to move the file but it's just obtaining this random filename that I'm having problems with.
Muchos gracias.
Reply With Quote