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.

The interesting thing is that I have a vb-sub that does the dala picking; and it works correctly from forms.


Thank you.



Ernest Aikins