Statistician
MIS
Can anyone help with my problem.
Basically I have a straight forward query in MS Access which makes use of a simple VBA function to performance a series of calculations. This query works perfectly fine in Access.
I have been trying to pull results of this query into MS Excel using the Get External Data feature.
However, whenever I try and pull in the query fields I keep getting an error stating that I have an undefined function in the expression.
I have tried adding drivers which relate to VBA and DAO but maybe I am doing something wrong.
Can anyone help???
Cheers
Dee
Basically I have a straight forward query in MS Access which makes use of a simple VBA function to performance a series of calculations. This query works perfectly fine in Access.
I have been trying to pull results of this query into MS Excel using the Get External Data feature.
However, whenever I try and pull in the query fields I keep getting an error stating that I have an undefined function in the expression.
I have tried adding drivers which relate to VBA and DAO but maybe I am doing something wrong.
Can anyone help???
Cheers
Dee