Duplicating PO Numbers

[gspotts]

My Purchase Order spreadsheet currently has a macro that, when a button labeled "Save PO" is clicked, saves the sheet as a .pdf then erases the data, increments the number and resaves to the master file. I believed this to be a fairly solid way to avoid the master file being saved over by someone clicking "Save As" as well as moving us toward an all digital purchasing system. I find, however, that due to the number of users for the file I am having duplicate numbers created when someone accesses the file while it is open, but before the previous user has saved. The only possibility I can see is to have the number increment and resave to the master immediately upon open, instead of on close. I am at a loss after the use of Google and this forum's search feature. The threads I have found from other forums recommend doing exactly what I am now, but that is not working. Any suggestions will be taken under advisement.

[mrice]

You could try writing the latest PO number to an external file and incrementing it everytime your workbook is open

On the ThisWorkbook tab

Please Login or Register  to view this content.

[gspotts]

I understand the method you are suggesting, but I am unfamiliar with the syntax you are using.

[gspotts]

I have used the following code and everything compiles, but there is no change made to my spreadsheet or my .txt file.

Please Login or Register  to view this content.

[mrice]

You will need to have a number in the text file to start with. Also, the text file will eventually need to be in a shared location so that all your users write to the same one.

Is the code in the ThisWorkbook tab?

Suggest declaring PONumber as a variant.