Using Excell Worksheet Functions

[John Conklin]

Is it possible to use Excel worksheet functions in Access?

In particular I want to use the NETWORKDAYS function to calculate the number
of workings days between two dates.

Any help or information greatly appreciated.

Thanks,
~John

 

[Dirk Goldgar]

Is it possible to use Excel worksheet functions in Access?

In particular I want to use the NETWORKDAYS function to calculate the
number of workings days between two dates.

Any help or information greatly appreciated.

You can do it, but you have to create an instance of an Excel
application object to do it with, and that's usually more overhead than
it's worth. If it's just NETWORKDAYS you need, look at the code posted
here:

http://www.mvps.org/access/datetime/date0006.htm

and here:

http://www.mvps.org/access/datetime/date0012.htm

 

[John Conklin]

Dirk,

Thank you very much for the info...I will give these a try.

~John

 

[John Conklin]

Dirk,

Thanks again, this did exactly what I needed.

Your help is greatly appreciated.

~John