VBA saving file with unique name

[BrianG86]

Hi,

I have a code that performs a task for me and will save the file at the end. It currently saves as a name I have selected and today's date. The problem I now face is that I will be completing this task several times a day and it will not work as the file names will be the same. Is there any way to save a unique name each time?

My code to save below:

ActiveWorkbook.SaveAs Filename:= _        "T:\Lender Updates\Lender Updates\Lloyds\Complete\Acknowledged " & Format(Date, "dd.mm.yyyy") & ".xlsm", _
        FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

 

[VoG]

Try like this

ActiveWorkbook.SaveAs Filename:="T:\Lender Updates\Lender Updates\Lloyds\Complete\Acknowledged " & Format(Now, "dd.mm.yyyy hhmmss") & ".xlsm", _
        FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

 

[BrianG86]

Thanks for this, it works well.

Is there a way to save it with a different reference each time though? So if the last file saved was 0001, then the next file should be 0002?

Thanks

 

[BrianG86]

Is anyone able to help here? I would like the file names to be saved with a unique reference that will go up one number at a time, so L001, next L002?

Thanks