Simply create a similar function (an UDF) in Excel, and use it!
In case this function needs some data from Access table(s) to be available, use ODBC query/queries to read those data into some hidden sheet(s) in Excel, and set those queries to be refreshed on open. And in your Excel UDF use hidden querytable(s).
|