Sub Page_HLMT_4()
Dim intPage As Integer, i As Integer, intSq As Integer, intRecord As Integer
Dim lngTotal As Long
With CreateObject("ADODB.Recordset")
.Open "Select * from [Sheet1$]", "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0 Xml;Data Source=" & ThisWorkbook.FullName, 1
.PageSize = 20
Sheet2.Cells.ClearContents
For intPage = 1 To .PageCount
lngTotal = 0
For intRecord = 1 To .PageSize
i = i + 1
intSq = intSq + 1
Sheet2.Range("A" & i) = intSq
Sheet2.Range("B" & i) = !ID & " >> " & !Code
Sheet2.Range("C" & i) = !Code
Sheet2.Range("D" & i) = Format(!Price, "0,#")
lngTotal = lngTotal + !Price
.MoveNext
If .EOF Then Exit For
Next
i = i + 1
Sheet2.Range("C" & i) = "Total:"
Sheet2.Range("D" & i) = Format(lngTotal, "0,#")
Next
End With
End Sub