MSOWCF.dll

[linger]

hi

does anyone know where i should put this library? i'm having problems using the functions. access does not recognize the names of the function. i've checked my office folder and MSOWCF.dll is in the folder. i've tried using all caps and no caps and caps on first alphabets for the functions but it still returns #Name?. does it matter where i put this file?

thanks...
frustrated!

 

[dk]

Hi,

Have you referenced it?

In the Visual Basic Editor choose Tools, References and click Browse. Then navigate the the msowcf.dll file. If the file is correctly registered then it should then become available to your project.

Hope this helps. By the way, I never knew about this particular file and it looks very useful so cheers mate!

 

[NateO]

Yeah, there is some good stuff going on here, you'll still want to bind even after having set your reference. Not sure how how to late bind to this, but here's an early bind example after following Dan's process:

<font face=Courier New><SPAN style="color:darkblue">Sub</SPAN> testkjkjdf()
<SPAN style="color:darkblue">Dim</SPAN> mFunc <SPAN style="color:darkblue">As</SPAN> MSOWCFLib.OCATP
<SPAN style="color:darkblue">Set</SPAN> mFunc = <SPAN style="color:darkblue">New</SPAN> MSOWCFLib.OCATP
<SPAN style="color:darkblue">Debug</SPAN>.<SPAN style="color:darkblue">Print</SPAN> Format(mFunc.EDATE(Date, 1), "MM")
<SPAN style="color:darkblue">Debug</SPAN>.<SPAN style="color:darkblue">Print</SPAN> mFunc.NETWORKDAYS(<SPAN style="color:darkblue">Date</SPAN> - 2, <SPAN style="color:darkblue">Date</SPAN>)
<SPAN style="color:darkblue">Debug</SPAN>.<SPAN style="color:darkblue">Print</SPAN> mFunc.ISEVEN(43)
<SPAN style="color:darkblue">Set</SPAN> mFunc = <SPAN style="color:darkblue">Nothing</SPAN>
<SPAN style="color:darkblue">End</SPAN> <SPAN style="color:darkblue">Sub</SPAN></FONT>