Import names of excel files to a String array

I have a folder with multiple excel files. I would like to write a function where the input argument is the route to the folder and the output is an array of String variables containing the names of the files, one for each position. The number of the files should be undefined and they have large names (40 characters average)

[Geoff Hayes]

Edison - perhaps look at dir and go from there.

[Edison]

Thanks, just what i needed