摘要：

【目的】使用excel宏程序从定版后的方正fbd小样文件提取多刊数据。【方法】使用InputBox语句由用户输入刊物代号、年份、期次,确定并打开fbd文件为excel文件,数据基本都在第一列单元格中,用Ctrl Find语句定位数据,用循环语句和判断语句采集一个或多个单元格数据,最后是对数据的处理和写入。【结果】程序可有效用于提取《河北科技大学学报》、《河北工业科技》两个刊物的中英文题目、作者、单位、摘要、关键词,以及doi、收稿日期、e-mail、参考文献等数据,程序运行过程中只需使用者输入刊物代号、年和期。【结论】单独使用excel宏程序即可实现所有数据的提取,相对简单易行。【局限】此种编程容错能力较差,要求期刊格式固定不变。

关键词: 期刊数据, excel, 宏程序, fbd

Abstract:

[Purposes] Using excelmacroprogram to extract data from the final.fbd file of Fangzheng software.[Methods] Using Inputbox for users to input the journal code,year and issue so that fbd files are determ ined and opened to be excel files,and the data is normal in the first column.Using ctrl finds statement to locate data,then using loop statement and judgment statement extracts data from one or some cells.Finally,the data is processed and w ritten in.[Findings] The program can be used to effectively extract data from Journal of Hebei University of Science and Technology and Hebei Journal of Industrial Science and Technology,including Chinese and English titles,authors,departments,abstracts and keywords,as well as DmagtechOI,remagtechceiveddates,e-mails,references,etc.In the operational process,the program only needs users to input the journal code,year and issue.[Conclusions] Using only excelmacroprogram can realize the extraction of various data,which is relatively simple and practicable.[Lim itations]The program has poor fault-tolerant capability,which entails that the journal format should be accurate and consistent.

Key words: Journal data, excel, Macroprogram, fbd