View Single Post
 
Old 08-10-2021, 05:28 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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).
Reply With Quote