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.