Search results

  1. В

    Getting UK postcode using address

    Yes, this method is slower than the method using the "MSXML2.XMLHTTP" object. Time is wasted opening Internet Explorer and navigating (entering an address, pressing a button ...) I rewrote the code of my function, however, sometimes I get an error on the line: "tempStr = Trim...
  2. В

    Getting UK postcode using address

    isladogs, add Microsoft Scripting Runtime in references.
  3. В

    Getting UK postcode using address

    Yes, I used the links that you recommended. I open the browser in invisible mode and get a list of postcodes for my address. If the address is not complete, then there will be more than 1 values.
  4. В

    Getting UK postcode using address

    If you find errors - please inform me
  5. В

    Getting UK postcode using address

    isladogs, Владимир = Vladimir Gasman, You are absolutely right! The result of my work: Public Function seachPostcode(ByVal txtAddress As String) As String Dim ie As Object Dim tempStr As String Dim myArray() As String Dim i As Integer Dim myDict As Dictionary Dim...
  6. В

    Getting UK postcode using address

    It is unlikely that my employer will want to buy a license. Nevertheless, thanks to all.
  7. В

    Getting UK postcode using address

    Thanks to Gasman. I knew that such a method is possible. However, with this method, the browser will open in visible mode (... Visible = True). I think that for my employer and users this will be unacceptable.
  8. В

    Getting UK postcode using address

    Hello isladogs I am from the Republic of Belarus. It is a small country between Poland and Russia. I have already seen your posts in similar topics. You always promote your database. ): As I already wrote, I do not need to find out the address. I already know the address. I want to find out...
  9. В

    Getting UK postcode using address

    Thank Gasman. I have already seen these sites, but I don’t know how to use the WinHttpRequest to go to the page with my postcode.
  10. В

    Getting UK postcode using address

    All I want is the ability to go to a page on a site using the address, which would be scraping postcode i.e., ".../ some website / City_Street Address_Street Address 2_House Number", for example
  11. В

    Getting UK postcode using address

    Hello everybody! And I apologize for my poor English. In my database there are fields on the form: House Number, Street Address, Street Address 2 and City. (Street Address 2 - this is an additional field). I would like to get the postcode of this address using webscraping. I know how to find...
Top Bottom