Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    85

    Unanswered: Forecast function

    I try to use the forecast function in Access 2007 using the object excel.
    I load two array's with values called varCol1 and varCol2
    I open the excel as object
    Debug.Print "Forecast:", obj.Forecast(2, varCol1, varCol2)
    Output is: Fout 2007.
    If I use Debug.Print "SumProduct:", obj.SumProduct(varCol1, varCol2)
    Output is: 1380
    I checked my array values in excel with the same function and then it is working.
    What do I mis?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I suspect this is more of an Excel problem.
    If no one can help, or you ask, I can move it there. Happy to leave here too.

  3. #3
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    85
    Actually it is calling from access an excel object to perform a calculation that is not available in access.
    Using Excel 2007 Functions in Access 2007 is the page i found to use the forecast function

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Yes, but since you can call another function from Access I'm thinking that the problem is more "Excelly" than "Accessy"; it is just the function syntax that is going wrong.

    Anyway, I will leave it here for now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •