Import function from MSExcel

[Guest]

How can I import function form MSExcel for using in MSAccess
and how to use function, for example funtion round, networkday

 

[Guest]

Hi Nova,

As far as I know, you cannot import functions from Excel. However, you can
call Excel functions:

How to call Excel functions from within Access 2000
http://support.microsoft.com/?id=198571

For later versions of Access, in step 3 set a reference to the Microsoft
Excel X.0 Object Library, where X=10 (Access 2002) or X=11 (Access 2003). You
can also use late binding to avoid the version specific references, but
that's something to work towards after all debugging is finished, since you
lose intellisense with late binding.

Access includes the Round function. It uses "banker's rounding" (you can
Google this term for a definition). Here is one hit:
http://www.teradataforum.com/teradata/20021106_141731.htm

A Networkday function is available here:
Doing WorkDay Math in VBA
http://www.mvps.org/access/datetime/date0012.htm

and
Calculate Number of Working Days
http://www.mvps.org/access/datetime/date0006.htm


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

How can I import function form MSExcel for using in MSAccess
and how to use function, for example funtion round, networkday