We want to make sure that all users use the updated version of FOREX rate (updated daily)

First, we need to warn the users to update the rates by a message box

To do that, a subroutine may be used:

Sub UpdateReminder()

MsgBox "Please remind to Update FPREX Assumptions including the Rates"

End Sub

Now, we need to create a central file including the rates and associated dates. This information has a path in our directory that can be accessible from (RATES_FILEPATH, RATES_FILENAME, RATES_RANGENAME)

We have two approaches to get data from the central file (ForexAssumptions.xlsx)

1- UpdateFOREX VBA code that asks the user for updating. Then, gets the updated rates from the central file, then currency excahnge calculations (FORX code) will run based on the updated information.

2- UpdateForexHistory VBA code that downloads the rate history in the central file as a table in a new sheet of the current workbook. Then inform the user of successful download. Now FORX VBA code can refer to the same workbook to get the forex rates.

The second option gives the user full flexibility to get data and work with that. Based on this function, the main page can be customized, so the user may pick a date. Based on the date, rates get updated from table in the other worksheet. This table has already downloaed from the central file. Now, based on the rates on the specific dates currency exchange calculation may be done.