EURO CONVERT

Posted by Fareed on July 04, 2001 10:12 AM

Hi,

Does anyone how to use the EURO CONVERT function in VBA code, for example you can use EXCEL functions such as WorksheetFunction.Sum(A1:b5:), etc.

I want to use the EURO CONVERT function like this can anyone help?

Thanks!

Posted by Dax on July 04, 2001 11:29 AM

Hello,

To use this do the following. Make sure the Euro Currency Tools add-in is installed. In the VB Editor click Tools, References and select Eurotool. You can then use the Euro conversion functions in VBA e.g.

Sub ConvertEuro()
Dim crcyConverted As Currency
crcyConverted = EUROCONVERT(1.2, "DEM", "EUR")
MsgBox crcyConverted
End Sub

HTH,
Dax.

Posted by Fareed on July 05, 2001 3:23 AM

Thanks, Mate your a life saver!!!