Where do I install Msowcf.dll?

[Banaticus]

I have a text box on a form with the Control Source set to: =Pi() It's giving me a #Name? error, as is Control Source: =Radians(34) Seeing this note in the help file related to Pi() ...

Some functions display the error #NAME? instead of a value.
Some of the spreadsheet functions are provided through a separate dynamic link library file, Msowcf.dll. If this file is missing, the functions display the #NAME? error value when you open the spreadsheet in your browser. Search for Msowcf.dll on your computer, and if it's missing, either reinstall Microsoft Office 2000 or contact your system administrator.

I searched my computer for Msowcf.dll and found it installed in:
C:\Program Files\Microsoft Access Runtim\Office10
C:\Program Files\Microsoft Office\Office
C:\Program Files\Microsoft Office\Office10

I'm using Office 2000 on this computer (Front Page 2002).

 

[TanisAgain]

You may need to register the DLL.

On the Start menu, click Run.

At the command prompt, type the following command to manually register the DLL:
regsvr32 filename.dll
where filename.dll is the file name of the DLL.

 

[Banaticus]

LoadLibrary(Msowcf.dll) failed - The specified module could not be found.

 

[Jon K]

I searched my computer for Msowcf.dll and found it installed in:
C:\Program Files\Microsoft Access Runtim\Office10
C:\Program Files\Microsoft Office\Office
C:\Program Files\Microsoft Office\Office10

If you can use the Pi() and the Radians() functions in Excel, you can also use them in Access.


To use the Excel functions on a form in Access, you have to:-

First, in Access, make a reference to the Microsoft Excel x.x Object Library (when the code window is open, select menu Tools, References...)

Then create wrapper functions (using VBA) to be used in the Control Source of text boxes on the form.


See database attached.
.