'********************************
'随机函数生成
'输入值:生成值范围 fromNum~toNum
'返回值:随机数
'********************************

Public Function Get_RandNum(fromNum,toNum)
  If (fromNum<0) Or (toNum<0) Then
   MsgBox "只接受大于零的输入"
  ElseIf fromNum>toNum then
   MsgBox "起始值必须小于结束值"
  Else
   Dim RunTime
   Randomize  
   RunTime = Int((10 * Rnd) + 1)
   Dim MyValue,i
   For i = 1 To RunTime
    Randomize 
    MyValue = Int(((toNum - fromNum + 1) * Rnd) + (fromNum))
   Next
     Get_randNum=MyValue
    End If
 End Function 
'********************************
 '随机生成(数字)
 '********************************
 Function MakeOnlyNum(inputlength)
  Dim I,x,B,A
  If IsNumeric(inputlength) Then
  For I = 1 To inputlength
   A = Array("0","1","2","3","4","5","6","7","8","9")
   Randomize
   x=Get_RandNum(0,9)
   B = A(x)
   MakeOnlyNum =MakeOnlyNum +B
  Next
   MakeOnlyNum = MakeOnlyNum
  else
   msgbox ("只接受数字输入")
  End If
 End Function 
'********************************
 '随机生成(字符串+数字)
 '********************************
 Function MakeString(inputlength)
  Dim I,x,B,A
  If IsNumeric(inputlength) Then
  For I = 1 To inputlength
   A = Array("0","1","2","3","4","5","6","7","8","9","a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z")
   Randomize
   x=Get_RandNum(0,35)
   B = A(x)
   makestring =makestring +B
  Next
   MakeString = makestring
  else
   msgbox ("只接受数字输入")
  End If
 End Function 
'********************************
 '随机生成(字符串)
 '********************************
 Function MakeOnlyString(inputlength)
  Dim I,x,B,A
  If IsNumeric(inputlength) Then
  For I = 1 To inputlength
   A = Array("a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z")
   Randomize
   x=Get_RandNum(0,25)
   B = A(x)
   MakeOnlyString =MakeOnlyString +B
  Next
   MakeOnlyString = MakeOnlyString
  else
   msgbox ("只接受数字输入")
  End If
 End Function