Results 1 to 3 of 3

Thread: ho to use the flag NAVNOHISTORY

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Mar 2005
    Posts
    2,943

    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:
    1. Sub RICERCA_ABI_CAB()
    2. 'HANS
    3.     Dim IE As Object
    4.     Dim lngRow As Long
    5.     Dim lngMaxRow As Long
    6.     Dim wksList As Worksheet
    7.  
    8.     Set wksList = ActiveWorkbook.Worksheets("ABICAB")
    9.     Set IE = CreateObject("InternetExplorer.Application")
    10.  
    11.     On Error GoTo errHandler
    12.     lngMaxRow = Range("A65536").End(xlUp).Row
    13.     With IE
    14.         .Visible = True
    15.         For lngRow = 2 To lngMaxRow
    16.  
    17.             .Navigate2 "http://www.bancaroma.it/abicab/index.asp"
    18.  
    19.             Do While .busy
    20.                 DoEvents
    21.             Loop
    22.             Do While .ReadyState <> 4
    23.                 DoEvents
    24.             Loop
    25.  
    26.             If wksList.Cells(lngRow, 3).Value = "" Then
    27.  
    28.                 With .document.Forms(0)
    29.                     'Abi
    30.                     .ABI.Value = Range("A" & lngRow)
    31.                     'Cab
    32.                     .CAB.Value = Range("B" & lngRow)
    33.                     .submit
    34.  
    35.                     Application.StatusBar = "Processing row " & lngRow & " of " & wksList.Range("A1").CurrentRegion.Rows.Count
    36.  
    37.                 End With
    38.                
    39.                 Do While Not CBool(InStrB(1, .document.URL, "?search"))
    40.  
    41.                     DoEvents
    42.                 Loop
    43.                
    44.                 Do While .busy
    45.                     DoEvents
    46.                 Loop
    47.                 Do While .ReadyState <> 4
    48.                     DoEvents
    49.                 Loop
    50.                 On Error Resume Next
    51.                              
    52.                 'CONSIDERARE PRIMA CELLA COME POSISZIONE "ZERO"
    53.                 Range("C" & lngRow) = UCase(.document.all.tags("table").Item(1).Rows(0).Cells(3).innerText)
    54.                 Range("D" & lngRow) = UCase(.document.all.tags("table").Item(1).Rows(1).Cells(3).innerText)
    55.                 Range("E" & lngRow) = UCase(.document.all.tags("table").Item(1).Rows(2).Cells(1).innerText)
    56.                 Range("F" & lngRow) = UCase(.document.all.tags("table").Item(1).Rows(3).Cells(1).innerText)
    57.                 Range("G" & lngRow) = Format(UCase(.document.all.tags("table").Item(1).Rows(4).Cells(1).innerText), "#00000")
    58.                                
    59.                 If Range("C" & lngRow) > 0 Then
    60.                     Range("H" & lngRow) = "OK"
    61.                 End If
    62.                
    63.                 On Error GoTo errHandler
    64.             End If
    65.         Next lngRow
    66.     End With
    67.  
    68. errHandler:
    69.     IE.Quit
    70.     Set IE = Nothing
    71.  
    72.     Exit Sub
    73.  
    74.     ActiveWorkbook.Save
    75.  
    76. End Sub

  2. #2
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,647

    Re: ho to use the flag NAVNOHISTORY

    You don't want to add the page to the IE history?

    VB Code:
    1. .Navigate2 "http://www.bancaroma.it/abicab/index.asp", &H2

  3. #3

    Thread Starter
    PowerPoster
    Join Date
    Mar 2005
    Posts
    2,943

    Re: ho to use the flag NAVNOHISTORY

    Quote Originally Posted by penagate
    You don't want to add the page to the IE history?

    VB Code:
    1. .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
  •  



Click Here to Expand Forum to Full Width