+ Reply to Thread
Results 1 to 5 of 5

Macro to get data from url.

  1. 09-05-2017, 02:36 AM #1
    UPA
    UPA is offline
    Registered User
    Join Date
    09-25-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    88

    Macro to get data from url.

    Hi,

    I am trying to get data from url below is the vba code which i am using to get data but unable to get complete data.

    My output should {"response": {"objects": [["natural_light", 612, 881, 1124, 1118]]}, "error": "false"} in range ("B2").

    below is my vba code.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 09-05-2017, 08:11 AM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Macro to get data from url.

    Hi UPA,

    In your .Open line of code, it ends with a ".jpg" which implies you are trying to get data from a picture file. Can you supply the correct URL for the site you are trying to scrape data from? If it is a picture, Excel won't be able to do it.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 09-06-2017, 12:40 AM #3
    UPA
    UPA is offline
    Registered User
    Join Date
    09-25-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    88

    Re: Macro to get data from url.

    Hi MarvinP,

    Thanks for the reply!

    Yes,I am trying to get data from picture file.

    Here is the correct url

    https://api.restb.ai/segmentation?cl.../110922317.jpg

    Regards
    upa
    Last edited by UPA; 09-06-2017 at 12:48 AM. Reason: url edit
    Reply With QuoteRegister To Reply
  4. 09-06-2017, 02:41 AM #4
    xlhelp7
    xlhelp7 is offline
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Macro to get data from url.

    May be

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 09-06-2017, 05:55 AM #5
    UPA
    UPA is offline
    Registered User
    Join Date
    09-25-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    88

    Re: Macro to get data from url.

    Hi xlhelp7,
    Thanks for the reply!
    That is exactly what I am looking for.
    Perfect!!!! Thanks so much for your assistance.

    Regrads,

    upa
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro fix space between data, Macro that takes cell information by name or data.
    By Maickol in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2015, 03:18 PM
  2. Macro template good saved but running macro with imported data problem
    By brazilexcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2015, 10:42 PM
  3. automatic macro with linking data in two workbooks, multiple row data to one row data
    By garfield8626 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2013, 01:47 PM
  4. [SOLVED] excel 2007 chart macro graphs data only from sheet on which macro was recorded
    By JW1028 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2013, 06:33 PM
  5. Macro to download monthly stock data and to refresh that data with the macro
    By Frankdude in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-23-2011, 08:38 PM
  6. Creating a macro to auto-update external data and time macro was excecuted
    By UNWATCHABLE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2010, 05:21 AM
  7. Optimizing Excel macro to find/replace with the list of data contained in the macro
    By Iceyburnz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-17-2008, 08:41 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1