ELUNA Document Repository

Using Excel and VBA with APIs to wow your colleagues and patrons

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.

[img] PDF (Presentation slides) - Published Version
Restricted to Registered users only



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.

Item Type:Conference or Workshop Item (Other)
Event Title:Ex Libris Northeast Users Group Conference
Subjects:General Topics
Divisions:Regional User Groups (RUGs) > Ex Libris Northeast User Group (ENUG)
ID Code:1591
Deposited By: Al Cornish
Deposited On:19 Nov 2017 22:39
Last Modified:19 Nov 2017 22:39

Repository Staff Only: item control page