Help: Trend equation formula from Excel to VB program

Environment:

Win32 (Windows NT, Windows95)

Visual Basic 4.0 (32-bit)

Office for Windows95

Using Excel version 7.0

The problem:

From a Visual Basic program, I pass a number of values to Excel, in

order to create a graph, in which the trend is calculated and

displayed. Currently, the trend is calculated as lineair regression

(formula: y = mx + b). I found out is is possible to get the equation

in the graph, and to pass the graph to teh Visual Basic program for

display, but I have to use the equation in other calculations on data

in the program. Since the equation in itself is known, it is

sufficient to get the values of m and b from Excel into the VB

program. However, I could find no way of doing that.

In another program, I need not only lineair regression, but

non-lineair functions as well. I now know of the wanted use of

logarithmic display, and there are more. I assume that there are

different formulas for these, but these can be written in a generic

form (like y = mx + b for the lineair regression) - so if I know the

type of display, all I need are the parameters used (as m and b)

Can anyone tell me: is it possible to get these values (or the whole

string so I can retrieve the data in the program) and if so, how to

get it?

Please e-mail the answer to:

Internet:

MSN:

Willem_Grooters

CompuServe:

101500,3612