Create a function for linear trend (forecast) 
Author Message
 Create a function for linear trend (forecast)

I think it works, but will not return a amount?

Function efc(amt1 As Variant, amt2 As Variant, amt3 As
Variant, amt4 As Variant, amt5 As Variant, amt6 As
Variant, amt7 As Variant, amt8 As Variant, amt9 As
Variant) As Variant
        Dim Myx As Variant
        Dim MyYs As Variant
        Dim MyXs As Variant
        Dim objExcel As Excel.Application
        Set objExcel = CreateObject("Excel.Application")

        Myx = amt1
        MyYs = Array(amt2, amt3, amt4, amt5)
        MyXs = Array(amt6, amt7, amt8, amt9)

        efc = Excel.Application.Forecast(Myx, MyYs, MyXs)

        objExcel.Quit
        Set objExcel = Nothing

End Function



Mon, 29 Aug 2005 06:26:19 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Forecast/Trend Functions

2. Using the Excel Trend Function from within VB

3. salary trends for programmers..wow!!

4. How can I trend Access data in VB?

5. Components for process visualization and trend logging

6. Help: Trend equation formula from Excel to VB program

7. Help - Trending report in the Drill-Down style in Crystal Reports 8.5

8. Database and Trending Control

9. show a trend chart in vb5 windows

10. entry/edit in tabular format - sales forecast database

11. Forecasting using Grid and Graph Controls using VB4.0 16bit

12. Grid Control with Moving Average Forecast

 

 
Powered by phpBB® Forum Software