Vba to save a file to a folder with the file name plus a sequential number

Hello,

I have a dashboard file that incorporates a number of user forms. I have created a new form that will dump data to a workbook and save to a folder as filename.xlsx... what I need is for that file name to contain a sequential number at the end and for vba to check the folder for the latest filename (number) and add one to that number at time of run as multiple people can access the dash board at the same time so I cannot have vba just remember a variable as that could result in a duplicate number being used. The only files that will be saved in this specific folder will be exports from this user form.

Please advise how you would go about this.

I have an API that uses Windows naming convention.

What is "your" naming convention?
e.g.
1. ken.xlsm, ken_1.xlsm
2. ken_1.xlsm, ken_2.xlsm
3. ken.xlsm, ken (1).xlsm
4. ken (1).xlsm, ken (2).xlsm
etc.

I figured out a solution by just counting the files in the folder and converting the count to an integer adding one each time its run and using saveas(filename & filenumber) no one can delete these files so it shouldn't be a problem this way