Converting Excel formulas to Access

T

TheNovice

All,

I have a formula that I have in Excel and I would like to use it in access.
in excel i use DEGREES, ACOS,SIN,RADIANS and ABS.

not all of these are in Access. Any Ideas?

Thanks,
 
S

strive4peace

you can use excel worksheet functions in Access. For example:

CeilingVariable = ExcelObject.WorksheetFunction.Ceiling(iOne, iTwo)

~~~~~~~~~~~
Sub test()
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
MsgBox xlApp.WorksheetFunction.Ceiling(306, 10)
xlApp.Quit
Set xlApp = Nothing
End Sub
~~~~~~~~~~~


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*
 
Top