Convert to euros dynamically

[amanbareilly]

Hi everyone.
I am trying to develop a module where we need to convert the currency from the excel workbook to euros and this needs to be done for multiple data several times a week. So converting to euros using an online tool is really time taking. Does anyone know some alternative so that I don't need to do this using a web tool?

 

[otonx]

Hi everyone.
I am trying to develop a module where we need to convert the currency from the excel workbook to euros and this needs to be done for multiple data several times a week. So converting to euros using an online tool is really time taking. Does anyone know some alternative so that I don't need to do this using a web tool?

http://access-excel.tips/get-foreign-exchange-rate-excel-vba/

 

[Tolani]

That sounds more like a VBA question, you can use a NumberFormat property of a range to achieve this for example,

https://www.mrexcel.com/forum/excel-questions/405143-formatting-currency-vba.html