title: VBA Excel Is it possible to generate running alphanumeric numbers instead everytime i open the workbook?
body: <p>i've recently have made a random 8digit ID Generator on my Form. But i was recommended to create a running alphanumeric number instead of the 8 random digit generator.. 
  The file im currently using is a saved template for me to send to users. so i was wondering if it's possible to have a running alphanumber number everytime they opened the file. i just couldnt think of any way to "store a main cell where it can keep +1 on the previous code" because this template is not saved everytime i open but is to send to other users.. </p>
  
  <p>Or is there anyway where the file can check on my database for the next number to be sent and generate it on the form? Thanks..</p>
  
  <p>Here is currently what i have for the 8 digit generator</p>
  
  <pre><code>Private Sub Workbook_Open()
      ' Called every time you open the excel document
  
      Dim myRandNumber As Long
      Randomize
      myRandNumber = CLng(Rnd() * 99999999)    ' CLng converts the floating point number to a long integer
  
      Dim rowNum As Integer
      Dim colNum As Integer
      rowNum = 6
      colNum = 4
  
      With ThisWorkbook.Sheets(MySheetName).Cells(rowNum, colNum)
      If (.Value = "") Then
      .Value = myRandNumber
  End If
  End With
  End Sub
  </code></pre>