使用VBA+RibbonX实现新媒体报告自动生成插件

详细信息    查看全文 | 推荐本文 |

英文篇名：Realization of New Media Report Automatic Generation Plug-in Using VBA&RibbonX 作者：武霖 英文作者：Wu Lin;State Administration of Press,Publication,Radio,Film and Television of The People's Republic of China,Station 292; 关键词：VBA ; Office ; RibbonX ; 视听新媒体 ; 办公自动化 英文关键词：VBA;;Office;;RibbonX;;Audiovisual New Media;;Office Automation 中文刊名：GBXX 英文刊名：Radio & Television Information 机构：国家广播电视总局二九二台; 出版日期：2018-10-15 出版单位：广播电视信息 年：2018 期：No.318 语种：中文; 页：GBXX201810026 页数：3 CN：10 ISSN：11-3229/TN 分类号：130-132

摘要

视听新媒体监管工作中,根据监测数据撰写监看报告是重要的一环,需要做到数据统计准确、格式标准,在公文流转中有着重要的地位。本文提出了一种基于VBA语言的报告自动生成方法,并基于RibbonX标准实现其用户界面,使代码插件化、可视化,提高监看工作的整体效率。
        In the supervision work of audiovisual new media, it is an important step to write the report based on the monitoring data. It needs to make the data statistics accurate, the standard of format, and has an important position in the circulation of public documents. This paper puts forward a method of automatic report generation based on VBA language, and implements its user interface based on RibbonX standard to make code a plug-in and visualization, and improve the overall efficiency of monitoring work.

引文

[1]王革田.VBA For Microsoft Excel在机械设计中的应用[J].机械制造,2003,41(10):57-59.
    [2]J Green,S Bullen,R Bovey,M Alexander.Excel 2007 VBA Programmer's Reference[M].Wrox Press Ltd.,2007,4(2):293.