Skip to main content
Parsing Citations using Visual Basic for Applications: A Step-by-Step Guide
Fransen, Janet L. (2012)
 

Title 
Parsing Citations using Visual Basic for Applications: A Step-by-Step Guide

Author(s)

Issue Date
2012-07-06

Type
Working Paper

Abstract
The most difficult hurdle in a citation analysis project is getting the citations from a set of bibliographies to a spreadsheet or database where they can be analyzed. When I approached my first citation analysis project in January 2011, I explored several methods for automating the process. This document describes the methods I tried, and their pros and cons, as well as the multi-step method I employed in the end. The process includes VBA code written for Microsoft Word and Microsoft Access. The code is not reproduced in this paper, but is available via email for other researchers wishing to use the same or a similar process.

Appears in Collection(s)

Suggested Citation
Fransen, Janet L.. (2012). Parsing Citations using Visual Basic for Applications: A Step-by-Step Guide. Retrieved from the University of Minnesota Digital Conservancy, http://purl.umn.edu/127017.


Content distributed via the University of Minnesota's Digital Conservancy may be subject to additional license and use restrictions applied by the depositor.