中国科技期刊研究 ›› 2019, Vol. 30 ›› Issue (3): 248-252.doi: 10.11946/cjstp.201809280860

• 质量建设 • 上一篇    下一篇

基于VBA编程实现编务工作整合

孟美任1,2),彭希珺1),华宁1),李春源1)   

  1. 1)中国科学院文献情报中心,北京市海淀区中关村北四环西路33号 100190
    2)中国科学院大学经济与管理学院图书情报与档案管理系,北京市海淀区中关村北四环西路33号 100190
  • 收稿日期:2018-09-28 修回日期:2018-11-19 出版日期:2019-03-15 发布日期:2019-03-26
  • 作者简介:孟美任(ORCID:0000-0002-0434-9504),硕士,馆员,E-mail: mengmr@mail.las.ac.cn;彭希珺,硕士,副研究馆员,编辑部主任;华 宁,硕士,编辑;李春源,学士,副研究馆员。|彭希珺,硕士,副研究馆员,编辑部主任|华 宁,硕士,编辑|李春源,学士,副研究馆员。

Integration of editorial work based on VBA

MENG Meiren1,2),PENG Xijun1),HUA Ning1),LI Chunyuan1)   

  1. 1)National Science Library, Chinese Academy of Sciences, 33 Beisihuan Xilu, Zhongguancun, Haidian District, Beijing 100190, China
    2)Department of Library, Information and Archives Management, School of Economics and Management, University of Chinese Academy of Sciences, 33 Beisihuan Xilu, Zhongguancun, Haidian District, Beijing 100190, China
  • Received:2018-09-28 Revised:2018-11-19 Online:2019-03-15 Published:2019-03-26

摘要:

【目的】探索集约化和多模式集中办刊思路,解决编务工作内容较为琐碎、各刊间存在大量重复工作、效率低下等问题,实现自动化整合编务工作。【方法】在需求分析的基础上,设计集约化、通用性的作者信息基础模块,利用Visual Basic for Applications(VBA)编程,实现自动化整合编务工作。【结果】实现基于作者信息表批量生成对接银行、单位财务、快递公司的相应信息表单。【结论】所提方法具有较高的可行性和可扩展性,能够提高编务工作效率,并为期刊整合工作提供借鉴。

关键词: 期刊整合, 编务工作, 自动化, Visual Basic for Applications (VBA)

Abstract:

[Purposes] Editorial work has low efficiency as a result of the massive and repeated affairs. In view of this, this paper tries to explore the intensive and multi-mode centralized operation ideas, and to achieve the automatic integration of editorial work. [Methods] First, we designed an intensive and versatile fundamental module, which recorded the author information, based on the requirement analysis. Then, we implemented automatic editorial work by Visual Basic for Applications (VBA) program. [Findings] We implement the integrated editorial work module, which batches creating forms automatically. [Conclusions] The proposed method has high feasibility and extendibility, and also benefits the integrated work of journals.

Key words: Journal integration, Editorial work, Automation, Visual Basic for Applications (VBA)