Runtime Error 1004

[mrc72]

I continue to receive a runtime error 1004 when I attempt to use the celing function in Access. I have created a module which looks like the following:

Public Function MyCeiling(inputval As Double, roundval As Double) As Double

MyCeiling = Excel.WorksheetFunction.Ceiling(inputval, roundval)
End Function

The Excel library 11.0 is checked and active. I get the results once, but can not export, sum the data, or run it again without removing the module and starting over.

Does anyone have any clues as to how to fix this?

 

[PHV]

MyCeiling = CreateObject("Excel.Application").WorksheetFunction.Ceiling(inputval, roundval)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mrc72]

PH - Thanks for the quick post. It appears to be working, but it is going slowly. I have over 500k lines and each one is taking 2 - 3 seconds to load and calculate. Any easy way around that?

MRC

 

[mrc72]

I also just received a "Run-time error 429 - ActiveX component cant create object" error and the calculation ended with no actual results. Thanks for the attempt PH.

 

[PHV]

Well, don't use excel just for a function !
Have a look here:
faq705-5031

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886