Results 1 to 10 of 10

a code to pull data from a website

Threaded View

  1. #1
    Registered User
    Join Date
    12-29-2012
    Location
    Latakia, Syria
    MS-Off Ver
    Excel 2010
    Posts
    61

    a code to pull data from a website

    Hi geniuses!
    In a cell B2 of a worksheet, the user enters a "doi" value (that is like an ID for any publication!). I am trying to find a code that translates this "doi" to a citation that I can use in my thesis. after a long search, I found a website that does this for me. this website is "https://citation.crosscite.org/". you simply need to insert the doi value (the content of B2 in my worksheet) in the designated box, hit "format" and you will get the citation on the same webpage. is there a way to automate this in excel by a vba? I know that is called "web scraping" but I wasn't able to make it to work in my case. any help will be super appreciated! (ps, you will be helping a scientist who is trying to kick cancer's ***!)

    Thanks a lot!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pull data from website?
    By nobrown in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2016, 08:19 AM
  2. Pull Website Source Code with Selenium (PhantomJS) VBA
    By mattmc419 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-18-2015, 05:02 AM
  3. Trying to pull data from website
    By SHUTTEHFACE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2014, 12:28 PM
  4. [SOLVED] VBA to Pull Data from Log in Website
    By rlee12 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-09-2013, 10:31 AM
  5. Pull Data from website.. can it be done?
    By sniderza in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-05-2012, 01:22 PM
  6. How can I pull the data next to a name from a website in VBA?
    By max3732 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-06-2010, 10:29 AM
  7. Pull data from website
    By djboston in forum Excel General
    Replies: 0
    Last Post: 01-02-2010, 01:47 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1