eprintid: 1591
rev_number: 7
eprint_status: archive
userid: 35
dir: disk0/00/00/15/91
datestamp: 2017-11-19 22:39:07
lastmod: 2017-11-19 22:39:07
status_changed: 2017-11-19 22:39:07
type: conference_item
metadata_visibility: show
creators_name: Zeng, Hao
creators_name: Klose Hrubes, Annamarie
title: Using Excel and VBA with APIs to wow your colleagues and patrons
ispublished: pub
subjects: gen
divisions: enug
abstract: Application Programming Interfaces (APIs) are a powerful way for libraries to gather data, including usage statistics, bibliographic information, and metrics. In the context of an academic library, the presenters will describe their workflow for pulling data from APIs into Excel with Visual Basic Applications (VBA). Using two examples , they will explain how and why this method provides a user-friendly solution that empowers other departments, inside and outside the library, to gather data independently. They will demonstrate their use of Scopus and Ulrich’s Web APIs.
date: 2017-10-19
full_text_status: restricted
pres_type: other
event_title: Ex Libris Northeast Users Group Conference
event_location: Jersey City, New Jersey
event_dates: October 19-20, 2017
event_type: conference
refereed: TRUE
citation: Zeng, Hao and Klose Hrubes, Annamarie (2017) Using Excel and VBA with APIs to wow your colleagues and patrons. In: Ex Libris Northeast Users Group Conference, October 19-20, 2017, Jersey City, New Jersey.
document_url: https://beta-documents.el-una.org/id/eprint/1591/1/Using%20Excel%20and%20VBA%20with%20APIs%20to%20Wow%20Your%20Colleagues%20and%20Patrons.pdf