ddurham
08-13-2008, 10:47 AM
Hello. This is my first post. I have an Access database that has some fairly complex calculations written in various modules. I have created several custom functions (with 2-5 parameters) that return a distinct value.
What I would like to do is call the custom VBA function via Excel by passing in several parameters.
Here is a simple example.
In an Excel field; the formula =ValueOfShip([shipname],[year])
In the Access database, there is a Public function called ValueOfShip that performs a complex calculations. In the end, a simple value is returned.
I have searched the web and seen a number of posting regarding call Excel via Access. But, i yet to have found something that works the other way.
Is this possible?
What I would like to do is call the custom VBA function via Excel by passing in several parameters.
Here is a simple example.
In an Excel field; the formula =ValueOfShip([shipname],[year])
In the Access database, there is a Public function called ValueOfShip that performs a complex calculations. In the end, a simple value is returned.
I have searched the web and seen a number of posting regarding call Excel via Access. But, i yet to have found something that works the other way.
Is this possible?