Hey
Is there anyway to perform Integration in excel using a VB program or something similar? More specifically is there any way to integrate things like secx?
Thanks in advance
Del
Printable View
Hey
Is there anyway to perform Integration in excel using a VB program or something similar? More specifically is there any way to integrate things like secx?
Thanks in advance
Del
Sounds like your wanting to automate Excel using VB6?
What is secx?
My guess is that he means integrate the trig function secant, sec(x) over a range of x. Probably needs a set of numerical integration routines.
This may be more than you bargained for, but check out xNumbers. It is an amazing (free) Excel Add-In with a wealth of functions and extremely high (200+ digit) accuracy. The user's guide is phenomenal. I used the routines to create a high accuracy linear matrix solver to solve sets of non-linear equations. Incredible routines. P.S. If you don't know Italian, the code comments won't do you much good.
http://digilander.libero.it/foxes/
VBAhack