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.
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.