利用VBA技术和EndNote软件建立查新报告数据库  

Development of Sci-tech Novelty Retrieval Report Database by Using Excel VBA and EndNote

作　　者：王磊[1] 张仁琼[1] 

机构地区：[1]合肥工业大学图书馆,安徽合肥230009

出　　处：《现代情报》2015年第8期131-136,140,共7页Journal of Modern Information

基　　金：安徽省高等学校图书情报工作委员会基金项目"MOOC环境下高校图书馆角色定位与服务创新研究"(项目编号:TGW14A02);合肥工业大学校级教学研究项目(项目编号:XJ201333)的研究成果之一

摘　　要：针对查新报告中各种有效信息未被整理、利用的现状,提出了一种利用VBA技术和EndNote软件建立查新报告数据库的方法。首先,利用Word VBA技术,依据文本特征从Word文档里抽取查新报告元数据项,之后利用Excel VBA技术将Word中的元数据项变为Excel数据,同时将Excel数据转换为EndNote可识别的文本文档从而建立了基于EndNote软件的查新报告数据库。A new approach was proposed to establish Sci - tech Novelty Retrieval Report Database by using VBA technology and Endnote software due to all the effective information of Sci - tech Novelty Retrieval Report was not effectively organized and uti- lized in status quo. First of all, metadata items of the S＆T Novelty Search Report were extracted from the word file based on text features. Secondly, metadata items of the Word file were converted to Excel data, which were also transformed into text file. Fi- nally, this paper load the recognized text file into the EndNote software. Thus the Seitech Novelty Retrieval Report Database was established based on EndNote software and VBA technology.

关 键 词：查新报告 数据抽取 VBA技术 ENDNOTE 

分 类 号：G250.7[文化科学—图书馆学]