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

Research output: 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.
Original languageEnglish (US)
StatePublished - Jul 6 2012

Fingerprint

Spreadsheets
Bibliographies
Electronic mail

Cite this

@techreport{60e1365cfb7c455ea06195801a6e8b30,
title = "Parsing Citations using Visual Basic for Applications: A Step-by-Step Guide",
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.",
author = "Jan Fransen",
year = "2012",
month = "7",
day = "6",
language = "English (US)",
type = "WorkingPaper",

}

TY - UNPB

T1 - Parsing Citations using Visual Basic for Applications

T2 - A Step-by-Step Guide

AU - Fransen, Jan

PY - 2012/7/6

Y1 - 2012/7/6

N2 - 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.

AB - 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.

M3 - Working paper

BT - Parsing Citations using Visual Basic for Applications

ER -