|
-
Jul 26th, 2005, 02:23 AM
#1
Thread Starter
PowerPoster
ho to use the flag NAVNOHISTORY
... Just this
My problem:
During the macro work from all record scanned maked a new link into History link (Chronology of visisted page into IE)... I have into official sheet 9118 record. 9118 = 9118 history link!!!!!!!!!!
Is possible to not insert all link into hiostory link of IE?
This is a piece of my recod:
column A and column B
01000 03246
01005 01009
01005 02401
01005 02602
01005 02806
01005 02808
01005 03251
01005 03418
01005 04606
01005 10202
01005 11703
01005 11711
01005 13801
01005 14501
01005 14801
01005 39102
01005 40100
01005 58020
01005 58480
01005 73160
01010 01007
01010 01008
01010 01600
01010 01601
01010 01602
01010 01603
01010 01604
01010 01605
01010 01606
01010 01607
01010 01608
01010 01609
01010 01610
01010 01611
01010 01612
01010 01615
01010 02400
01010 02403
01010 02800
01010 02802
01010 02803
01010 03000
01010 03001
01010 03002
01010 03003
01010 03200
01010 03202
01010 03203
01010 03204
VB Code:
Sub RICERCA_ABI_CAB()
'HANS
Dim IE As Object
Dim lngRow As Long
Dim lngMaxRow As Long
Dim wksList As Worksheet
Set wksList = ActiveWorkbook.Worksheets("ABICAB")
Set IE = CreateObject("InternetExplorer.Application")
On Error GoTo errHandler
lngMaxRow = Range("A65536").End(xlUp).Row
With IE
.Visible = True
For lngRow = 2 To lngMaxRow
.Navigate2 "http://www.bancaroma.it/abicab/index.asp"
Do While .busy
DoEvents
Loop
Do While .ReadyState <> 4
DoEvents
Loop
If wksList.Cells(lngRow, 3).Value = "" Then
With .document.Forms(0)
'Abi
.ABI.Value = Range("A" & lngRow)
'Cab
.CAB.Value = Range("B" & lngRow)
.submit
Application.StatusBar = "Processing row " & lngRow & " of " & wksList.Range("A1").CurrentRegion.Rows.Count
End With
Do While Not CBool(InStrB(1, .document.URL, "?search"))
DoEvents
Loop
Do While .busy
DoEvents
Loop
Do While .ReadyState <> 4
DoEvents
Loop
On Error Resume Next
'CONSIDERARE PRIMA CELLA COME POSISZIONE "ZERO"
Range("C" & lngRow) = UCase(.document.all.tags("table").Item(1).Rows(0).Cells(3).innerText)
Range("D" & lngRow) = UCase(.document.all.tags("table").Item(1).Rows(1).Cells(3).innerText)
Range("E" & lngRow) = UCase(.document.all.tags("table").Item(1).Rows(2).Cells(1).innerText)
Range("F" & lngRow) = UCase(.document.all.tags("table").Item(1).Rows(3).Cells(1).innerText)
Range("G" & lngRow) = Format(UCase(.document.all.tags("table").Item(1).Rows(4).Cells(1).innerText), "#00000")
If Range("C" & lngRow) > 0 Then
Range("H" & lngRow) = "OK"
End If
On Error GoTo errHandler
End If
Next lngRow
End With
errHandler:
IE.Quit
Set IE = Nothing
Exit Sub
ActiveWorkbook.Save
End Sub
-
Jul 26th, 2005, 07:25 AM
#2
Re: ho to use the flag NAVNOHISTORY
You don't want to add the page to the IE history?
VB Code:
.Navigate2 "http://www.bancaroma.it/abicab/index.asp", &H2
-
Jul 26th, 2005, 07:47 AM
#3
Thread Starter
PowerPoster
Re: ho to use the flag NAVNOHISTORY
 Originally Posted by penagate
You don't want to add the page to the IE history?
VB Code:
.Navigate2 "http://www.bancaroma.it/abicab/index.asp", &H2
tks Penagate, but the macro add always the link into Hostory lit....;-(
If you like test the macro with official data, or i send you a little sheet?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|