juggernautofmodernity
New Member
- Joined
- Mar 8, 2015
- Messages
- 1
I am very new to VBA, and so any help the experienced Excel community could offer me would be greatly appreciated!
In an Excel spreadsheet, I have a column list of 11,945 Google Scholar URLs for specific research articles in Google Scholar's database search. Most of these research articles provided useful results and support for later research, and have received citations from other researchers. When viewing each article, beneath the article abstract Google Scholar displays the number of citations each article received from other reesearchers (e.g. "Cited by 119"). The list of 11,945 Google Scholar URLs can viewed on my website here: https://carledwardsmithiii.wordpress.com/thesis-hyperlinks/
I have been experimenting with VBA code to develop a macro that will move through this list of URLs, extract the number of citations each article received, and return the value to the cell next to the URL (i.e. return Google Scholar citation number in cell B1 based on Google Scholar article URL in cell A1). Unfortunately, I do not know much about VBA or macros, I only know a little about web queries, and I have had no luck with my experimentation. Fortunately, the online community has been a great resource---I came across Mr. Excel Tip 72, and about halfway down the page, the third set of code does something effectively similar and it seems that this may be possible for my situation: Excel Web Queries to Download a Database
I would greatly appreciate it if anyone could offer advice on how to adapt this code to my situation.
In an Excel spreadsheet, I have a column list of 11,945 Google Scholar URLs for specific research articles in Google Scholar's database search. Most of these research articles provided useful results and support for later research, and have received citations from other researchers. When viewing each article, beneath the article abstract Google Scholar displays the number of citations each article received from other reesearchers (e.g. "Cited by 119"). The list of 11,945 Google Scholar URLs can viewed on my website here: https://carledwardsmithiii.wordpress.com/thesis-hyperlinks/
I have been experimenting with VBA code to develop a macro that will move through this list of URLs, extract the number of citations each article received, and return the value to the cell next to the URL (i.e. return Google Scholar citation number in cell B1 based on Google Scholar article URL in cell A1). Unfortunately, I do not know much about VBA or macros, I only know a little about web queries, and I have had no luck with my experimentation. Fortunately, the online community has been a great resource---I came across Mr. Excel Tip 72, and about halfway down the page, the third set of code does something effectively similar and it seems that this may be possible for my situation: Excel Web Queries to Download a Database
I would greatly appreciate it if anyone could offer advice on how to adapt this code to my situation.
