MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Access queries and Excel functions

Posted by John S on July 02, 2001 7:12 AM

I need to call an Excel function to run a calculation within an Access97 query, from two fields created by the query. I tried the following:

NewValue: Application.Excel.WorksheetFunction.functionname(field1, field2)

but this gave me an error when editing.

Any suggestions?


Posted by Aladin Akyurek on July 02, 2001 9:03 AM


Just curious: Is it a specific or any Excel function that you want to call upon? If it is a specific func, which one is that?


Posted by John S on July 02, 2001 11:28 AM

It's actually a user-defined function that was developed for Excel by some folks that are no longer with our company. I could create a similar one in Access, but was trying the easiest path first, being a short work week and all ...