Is there any code which would enable me to save the excel file as a predefined sequential number.

I.E. I have products with serial numbers 050501AB, 050502AB etc etc

The serial number is scanned in by a barcode reader and located in a predefined cell.
I want to save the excel workbook as this serial number automatically.

Any help would be appreciated.