[jimrenoir]

Καλησπέρα σε όλο το φόρουμ.
Θανάση ευχαριστώ για την απάντηση.Σου παραθέτω τον κώδικα για να δείς.Και αν μπορείς να μου κάνεις αυτήν την διόρθωση
Option Explicit

Private Declare Function FindWindow Lib "user32" Alias _
"FindWindowA" (ByVal lpClassName As String, ByVal _
lpWindowName As String) As Long
Private Declare Function GetWindowLong Lib "user32" Alias _
"GetWindowLongA" (ByVal hwnd As Long, ByVal nIndex _
As Long) As Long
Private Declare Function SetWindowLong Lib "user32" Alias _
"SetWindowLongA" (ByVal hwnd As Long, ByVal nIndex _
As Long, ByVal dwNewLong As Long) As Long
Private Declare Function DrawMenuBar Lib "user32" (ByVal _
hwnd As Long) As Long
Private Declare Function SendMessage Lib "user32" Alias _
"SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, _
ByVal wParam As Long, lParam As Any) As Long
Private Declare Function ReleaseCapture Lib "user32" () As Long

Private hwndHandle As Long, GWL_STYLE, frm As Long, hwndStyle As Long

Private Const DefaultURL = "URL;http://www.oddsfair.net/index.php?date=2011-10-13&league=%&order=timeasc"

Private Sub ImportDataFromWeb()
Dim OffsetX As String, i As Integer, LastRow As Integer
OffsetX = "&offset="
With BaseSheet
For i = 1 To 1
DoEvents
.QueryTables(1).Connection = DefaultURL
.QueryTables(1).Refresh BackgroundQuery:=False
SheetAllData.Range("A4:O5000").ClearContents
LastRow = 4
MergeData LastRow
LastRow = BaseSheet.Range("xPage").Rows.Count + 2
Next
i = 0
Do While .Range("xPage").Rows.Count > 2
DoEvents
i = i + 20
.QueryTables(1).Connection = DefaultURL & OffsetX & i
.QueryTables(1).Refresh BackgroundQuery:=False
MergeData LastRow
LastRow = LastRow + BaseSheet.Range("xPage").Rows.Count - 2
Loop
End With
End Sub