Re-order Files in a Folder using an Array

[jagrenet]

Good Day Gurus !!

I have an idea I am trying to get to work but, not sure exactly how to approach it, .... or if it can be done.
I have a folder with files,(13 files) all of the same type, and date, .... the only thing different are the names and length of names.

By default, they are listed Alphabetically.
What I am needing to do is "sort" them in a very specific order which is not Alphabetical. I have the filenames in a spreadsheet listed in the order I need and have that order assigned to an array.
Is there a way to use my array with DIR() ..... FSO ..... or some other method to re-arrange the files from within my VBA code, that would not require any user input?

Thanks in advance !!

 

[Herakles]

All I can think is that you give each file a prefix which places them in the right ascending order.

 

[jagrenet]

All I can think is that you give each file a prefix which places them in the right ascending order.

I had considered that. But instead, using a "suffix" just prior to the extension. Something like "FilenameThis-1.docx .... FillenameThat-2.docx" and so on. With that in mind, ... the Array is already ordered the way I need it to be so, ..... is there a way to utilize the Array Indexes to make that happen, at runtime ?? - For that matter, ..... the filenames could be prefixed with the Array Index numbers and that would be just fine as well. These files are ultimately going to be deleted at the end anyway. Can I make my code do that ???