摘要：

【目的】探索集约化和多模式集中办刊思路,解决编务工作内容较为琐碎、各刊间存在大量重复工作、效率低下等问题,实现自动化整合编务工作。【方法】在需求分析的基础上,设计集约化、通用性的作者信息基础模块,利用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)