基于VBA编程实现编务工作整合
|
摘要
【目的】探索集约化和多模式集中办刊思路,解决编务工作内容较为琐碎、各刊间存在大量重复工作、效率低下等问题,实现自动化整合编务工作。【方法】在需求分析的基础上,设计集约化、通用性的作者信息基础模块,利用Visual Basic for Applications(VBA)编程,实现自动化整合编务工作。【结果】实现基于作者信息表批量生成对接银行、单位财务、快递公司的相应信息表单。【结论】所提方法具有较高的可行性和可扩展性,能够提高编务工作效率,并为期刊整合工作提供借鉴。
[Purposes] Editorial work has lowefficiency as a result of the massive and repeated affairs. In viewof 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.
[Purposes] Editorial work has lowefficiency as a result of the massive and repeated affairs. In viewof 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.
引文
[1]中国科学院.中国科学院“十三五”发展规划纲要[R/OL].(2016-09-02)[2018-05-09]. http:∥www. cas. cn/yw/201609/W020160906628615831929.pdf.
[2]杨西京.后转制时期现代出版企业的管理模式[J].科技与出版,2012(6):26-28.
[3]韩丽,武文.如何实现科技期刊管理、发行中快递单据的批量打印[J].中国科技期刊研究,2013,24(5):932-934.
[4]李庚,魏玉芳,邢乐林,等.提高期刊编务工作效率的方法[J].编辑学报,2018,30(3):282-284.
[5]陈佳佳.基于工作流的出版工作编务系统的设计与实现[J].北京工业职业技术学院学报,2018,17(2):30-35.
[6]叶婷婷,黄河胜.科技期刊不同编务模式的比较研究[J].编辑学报,2016,28(4):373-375.
[7]林海妹,薛刚,李永龙,等.科技期刊编务人员的服务意识及其与期刊发展的关系[J].编辑学报,2014,26(1):57-58.
[8]胡运梅.高校学报编务工作的问题及对策[J].长春师范大学学报,2017,36(12):196-197.
[9]周德进.中国科学院原属期刊编辑部整合经验交流会[EB/OL].(2017-08-25)[2018-05-19]. http:∥www. las. cas. cn/xwzx/zhxw/201708/t20170825_4851787.html.
[2]杨西京.后转制时期现代出版企业的管理模式[J].科技与出版,2012(6):26-28.
[3]韩丽,武文.如何实现科技期刊管理、发行中快递单据的批量打印[J].中国科技期刊研究,2013,24(5):932-934.
[4]李庚,魏玉芳,邢乐林,等.提高期刊编务工作效率的方法[J].编辑学报,2018,30(3):282-284.
[5]陈佳佳.基于工作流的出版工作编务系统的设计与实现[J].北京工业职业技术学院学报,2018,17(2):30-35.
[6]叶婷婷,黄河胜.科技期刊不同编务模式的比较研究[J].编辑学报,2016,28(4):373-375.
[7]林海妹,薛刚,李永龙,等.科技期刊编务人员的服务意识及其与期刊发展的关系[J].编辑学报,2014,26(1):57-58.
[8]胡运梅.高校学报编务工作的问题及对策[J].长春师范大学学报,2017,36(12):196-197.
[9]周德进.中国科学院原属期刊编辑部整合经验交流会[EB/OL].(2017-08-25)[2018-05-19]. http:∥www. las. cas. cn/xwzx/zhxw/201708/t20170825_4851787.html.