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
Bookmarks