VBA to select a file to open from a sharepoint site

[not_IT]

I am attempting to code a macro to open a sharepoint site and allow for a user to select the appropriate file to open. The name of the file changes constantly (date of file creation in filename) but will always be available from the same file location.

Is there a means to do this