Executing Access user defined functions from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John B - 27 Dec 2005 01:17 GMT

I have a query that calls a user defined function in Access.

e.g. GetCurrentBatchID (gets the current batch ID).
Query1
Select getcurrentbatchID(), items, destination FROM Tbl

I would like to create a pivot table from this query (Query1) in Excel but
Excel complains that the user defined function is not "defined".

JB

Reply to this Message

Douglas J. Steele - 27 Dec 2005 01:58 GMT

Try using Automation. See http://support.microsoft.com/?id=210111 for some
details.

Otherwise, it's not possible, since when you query the data from outside of
Access, you're strictly using Jet, which doesn't know anything about
user-defined functions.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have a query that calls a user defined function in Access.
>
[quoted text clipped - 6 lines]
>
> JB

Reply to this Message

John B - 27 Dec 2005 02:20 GMT

I see, thanks for the confirmation. I resorted to creating a batch vba code
to generate the tables from the queries to be used in Excel.

JB

> Try using Automation. See http://support.microsoft.com/?id=210111 for some
> details.
[quoted text clipped - 13 lines]
> >
> > JB

Reply to this Message