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!
Bookmarks