Running Access queries containing user defined functions in Excel
Posted on 2011-10-06
Hi, I have an Access database with queries which references user defined function located in a module in the database. The query runs fine in Access.
I would like to run this query from VBA Excel so I can dump the results into my spreadsheet. However, I am getting an error saying that my user defined function cannot be found: Run-time error '3085' Undefined function 'userfunction' in expression.
Is there a work around to this? I tried cutting and pasting the Access vba code for that function into the Excel module, but am getting the same error.
Thanks in advance!