How I calculate an integral in VBA for excel

[Mauro]

I am traing to calculate an integral of a function obtained from a x-y chart
using a serie of xi, yi experimental data. Exist a code for VBA that permits
to obtain a function of a serie of data and evaluet its integral value for
each xi, whit a good precision ? I am a not experienced VBA programer. Thks

 

[Tom Ogilvy]

http://www.engineering.usu.edu/cee/...ExamplesFromLectures/NumericalIntegration.zip

A zip file of code from this site:

http://www.engineering.usu.edu/cee/...VisualBasic6_Gottfried_Summaries_Examples.htm

 

[Tom Ogilvy]

You can also use this google search

http://www.google.com/search?hl=en&q=vb6+code+"numerical+integration"&btnG=Search

to look at some of the other sources of information.