get file name using vba in access[resolved]

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.

Sorted. In case anyone's interested:

VB Code:

Private Sub Form_Load()
Dim myfile As String
myfile = Dir("C:\myfolder\*")
MsgBox myfile
End Sub