Dear Excel experts,

I am struggling with calculations extracted from Access database with
Excel VBA. Is it possible to use custom function with SQL statement?

A normal SQL statement will be like;
SELECT A,B from C

Can I do the following with Excel VBA like;
SELECT function(A,B) from C

I have tried it but failed. I am not sure if this is because this
cannot be done in Excel or I didn't know the right way to do it.

Thank you very much in advance.

th efunction must include a database name where the macro is located.

db1.mdb!function(a,b)


"Roth" wrote:

Dear Excel experts,

I am struggling with calculations extracted from Access database with
Excel VBA. Is it possible to use custom function with SQL statement?

A normal SQL statement will be like;
SELECT A,B from C

Can I do the following with Excel VBA like;
SELECT function(A,B) from C

I have tried it but failed. I am not sure if this is because this
cannot be done in Excel or I didn't know the right way to do it.

Thank you very much in advance.

SELECT GetCoupon([Security]) FROM BondTables

raised an "Undefined Function" error in Excel,. In my Access database, its a
public function




"Joel" wrote:

th efunction must include a database name where the macro is located.

db1.mdb!function(a,b)


"Roth" wrote:

Dear Excel experts,

I am struggling with calculations extracted from Access database with
Excel VBA. Is it possible to use custom function with SQL statement?

A normal SQL statement will be like;
SELECT A,B from C

Can I do the following with Excel VBA like;
SELECT function(A,B) from C

I have tried it but failed. I am not sure if this is because this
cannot be done in Excel or I didn't know the right way to do it.

Thank you very much in advance.