<div>
<div class="content wysiwyg-content">
Hi Experts, 
 
I have this type of data 
 
WeekNo &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SC_Dly_ProjAccurcy_Avg_Last_x_Wks 
13 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.924868312317044 
14 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.934322001485006 
15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.906667898893364 
16 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.95072420264395 
 
How can I programmatically use the Excel slope function within Access? 
 
I have this code : 
&nbsp; &nbsp; Dim xlApp As Object 
 
&nbsp; &nbsp; Set xlApp = CreateObject(&quot;Excel.Application&quot;) 
 
&nbsp; &nbsp; 'Use SLOPE() in an expression: 
&nbsp; &nbsp; 'SomeVariable = xlApp.Slope(y, x) 
 
&nbsp; &nbsp; xlApp.Quit 
&nbsp; &nbsp; Set xlApp = Nothing 
 
 
THANKS 

</div>
</div>

Hi Experts,

I have this type of data

WeekNo	SC_Dly_ProjAccurcy_Avg_Last_x_Wks
13	0.924868312317044
14	0.934322001485006
15	0.906667898893364
16	0.95072420264395

How can I programmatically use the Excel slope function within Access?

I have this code :
    Dim xlApp As Object

    Set xlApp = CreateObject("Excel.Application")

    'Use SLOPE() in an expression:
    'SomeVariable = xlApp.Slope(y, x)

    xlApp.Quit
    Set xlApp = Nothing


THANKS


How to pass a record set to the Excel slope function in Access?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.