Fire Access Make-Table Query from Excel

I have a make-table query in an Access DB that uses custom functions to return some of the field values which I believe prevents me from obtaining the same view from within Excel. I would like to run the query from Excel if possible. I was heading down this path:

Sub AllQueries()
Dim dbs As Object
Set dbs = New Access.Application
dbs.OpenCurrentDatabase "J:\DeveloperProjects\Access\DT-Reports-Dev.mdb"
dbs.CurrentData.AllQueries.Item(15) 'I ran out of options here
End Sub

Any ideas?
Thanks,
Andrew