Jimbo
After lots of research I have come up with a suitable currency conversion program for you...

VB Code:
  1. Function Rand(CurrName as String, Conversion as Double, _
  2.    Amount as Double) as Double
  3.  
  4.      Select Case CurrName
  5.             Case "AUD": Rand = Amount * 0
  6.             Case "GBP": Rand = Amount * 0
  7.             Case "USD": Rand = Amount * 0
  8.             Case "YEN": Rand = Amount * 0
  9.             Case "EUR": Rand = Amount * 0
  10.             Case "DM": Rand = Amount * 0
  11.             Case "FF": Rand = Amount * 0
  12.             Case "ITL": Rand = Amount * 0
  13.      End Select
  14. End Function