I did search many times to find a proper solution, but till today I didn't find a proper solution for my function. Target is to open a schedule from the server using VBA either from within MS Project or MS Excel using only part of the mpp filename. We do have a ProjectID for each schedule. Unfortunately, this is only part of the file name and the rest even changes from time to time: Example: ProjectID_Department_Projectname
With FileOpenEx I can easily open a file from the server using full file name. I wonder now if there is a way to use part of the name. -Is there a function to open a file using placeholders? or alternatively -Does anyone know how to loop through all files on project server or retrieve a list of files?