PDA

View Full Version : Call MS Access function in module via Excel



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?

Aussiebear
08-22-2008, 10:48 PM
As I understand your request, you want to call Access for a value to use in Excel. Is this right?

ddurham
08-25-2008, 01:50 PM
That is correct. i want to pass parameters to an access function and use the values in excel