Function RndFileName()
  'This function will generate an alpha-numeric random 8.3
  'file name that ends in .tmp. This function does not accept
  'any arguements.
  'This script is provided under the Creative Commons liscense located
  'at http://creativecommons.org/licenses/by-nc/2.5/ . It may not
  'be used for comercial purposes with out the expressed written consent
  'of NateRice.com
 
  For x=1 To 8
    Randomize
    vChar = Int(36*Rnd)
    If vChar < 10 Then 'append number
      RndFileName = RndFileName & vChar
    Else 'else append a letter
      RndFileName = RndFileName & Chr(97+(vChar-10))
    End If
  Next

  RndFileName = RndFileName & ".tmp"

End Function