+ Reply to Thread
Results 1 to 1 of 1

Unable to fetch data from Website through VBA Code

  1. #1
    Registered User
    Join Date
    07-03-2016
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    38

    Unable to fetch data from Website through VBA Code

    Hi,

    I am using Windows 10 with IE11. In attached file named "Book1", I am trying to fetch data from 21 URLs through VBA code. Sometime it run successfully and generates the results and sometimes it randomly throws errors like, (1)We connected to the website, but didn’t receive any data from it. Error Code: INET_E_DATA_NOT_AVAILABLE (2) The connection to the website was reset. Error Code: INET_E_DOWNLOAD_FAILURE. This typically happens only with 4 URLs highlighted in yellow in attached file. When I open this pages in internet explorer 11, then also it randomly throws such error in only this 4 URLs. I have googled this issue and tried every possible solution, but still no success.

    Can someone explain that is it issue related to internet explorer being slow or internet connection is slow or it is URL specific problem. Please note that these URLs are opening successfully in Chrome without any error. Error occurs only in Edge and Internet Explorer Browser. So it seems more like browser related problem.

    Can someone guide me what is the exact problem and how to resolve it??? I am really

    Is it possible to fetch data directly with some another method like VBA code in another attached file "Indice Data". I dont know such VBA code and got this code through someone else on this forum.

    Please help someone.....
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Unable to Fetch Data Based on Selected Date
    By Sanjibghosh in forum Excel General
    Replies: 2
    Last Post: 01-13-2017, 12:17 PM
  2. Get Data from a Website - Unable to click Button
    By karan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2016, 04:45 PM
  3. Unable to Pull data from a Website
    By captaincrazzy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2015, 03:58 PM
  4. Replies: 8
    Last Post: 02-09-2015, 11:52 AM
  5. Unable To fetch Data
    By vipul520 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-14-2013, 05:16 AM
  6. fetch header from website - excel vba
    By sethu_bala1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2013, 02:45 AM
  7. fetch website data into excel using vba excel macro
    By alejandro.c in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2013, 10:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1