Functions

hello all,

i have 2 built in functions in Excel that do a specific calculation for me. one is the Edate("string",date1,date2) functionn and the other is the Xirr(...) function (available with the analysis toolpak).

now, i have created a MSAccess 97 database to do a more complicated calculation and i need to use these functions but they are not avaiable in Access 97 (doesn't anyone but me find that annoying?).

what can i do?

Adi

If the functions are in a standard module you should be able to export the module and then inport it into Access. Select the module in the project explorer and right click. There is an Export File option.

I think therefore I am... sometimes right. images/icons/wink.gif

unfortunately, i am refering to the Excel based standard functions and i don't know how to reach the module that holds them.

You are talking about built-in functions in Excel? You could try adding
a reference to Microsoft Excel 9.0 Object Library. I don't know if that
will help or not but worth a try.

I think therefore I am... sometimes right. images/icons/wink.gif

yes, it is built in functions is excel and i have tried that (i only had 8 not 9).

but it still didn't work as i have no idea if they are available now and if so, how do i find out.

i tried entering the Edate() function but Access didn't recognise it.

Please Help

Edate() is simply a DateAdd() function that only uses months.. Use 'DateAdd("m", lngNumberOfMonths, startdate)'

As for Xirr(...) ,,, if you *really* need this, I think you may have to use CreateObject() to open an Excel file in memory containing a procedure with the Xirr() function then pass the arguments it..

Access is a database tool, Excel is for analysis - then there's automation... ~;-]