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.
Bookmarks