Hi


I have some pivot tables/graphs in Excel with data linked to an Access query.


What I'd like to do is get the query to derive a value from a VBA function I've made in a module within Access, so I can use this data in Excel.




The function runs fine in the query from within Access, it's when I try to link to the query from Excel I run into a brick wall.


It seems this isn't possible because I either get an unrecognised function message, or the query does not appear in the list of possible links when I try to connect, depending on whether I connect via Data/From Access or Data/From Other Sources.


Does anyone know how I can connect to an Access query with a function call in it?