Using Excel and VBA with APIs to Wow Your Colleagues and Patrons

Please use this identifier to cite or link to this item: https://hdl.handle.net/20.500.12202/19

Full metadata record

DC Field	Value	Language
dc.contributor.author	Zeng, Hao
dc.contributor.author	Klose Hrubes, Annamarie
dc.date.accessioned	2018-02-12T15:17:13Z
dc.date.accessioned	2018-05-01T17:57:01Z
dc.date.available	2018-02-12T15:17:13Z
dc.date.available	2018-05-01T17:57:01Z
dc.date.issued	2017-10
dc.identifier.uri	https://hdl.handle.net/20.500.12202/19
dc.description	This presentation was given at the ExLibris Northeast User Group (ENUG) conference in Jersey City, New Jersey, on October 18, 2017.	en_US
dc.description.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.	en_US
dc.language.iso	en_US	en_US
dc.subject	API
dc.subject	VBA
dc.title	Using Excel and VBA with APIs to Wow Your Colleagues and Patrons	en_US
dc.type	Presentation	en_US
Appears in Collections:	Library Staff Publications

Files in This Item:

File	Description	Size	Format
Using Excel and VBA with APIs to Wow Your Colleagues and Patrons.pdf		1.16 MB	Adobe PDF	View/Open