OWC Pick database figures

[aikins]

I have written a visual basic application to do simple accounting. I
have included the OWC version of excel to help prepare accounts from
the
underlying database which is in access.

Question:

Is there a way of creating a custom function to pick and drop values
from the database to excel? What I require is e.g

A formulae like =accountbalance(220000) will run a query on the
database
and drop the balance of account 220000 in the cell.

 

[Alvin Bruney [MVP]]

Yup, you could write a UDF or COM class that would be callable from the
spreadsheet as =accountbalance(220000) .
--
--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99