| 利用VBA编程实现生产日报表的自动生成 |
| |
| 引用本文： | 杨廷福,王会梅.利用VBA编程实现生产日报表的自动生成[J].电脑编程技巧与维护,2012(20):23-25. |
| |
| 作者姓名： | 杨廷福 王会梅 |
| |
| 作者单位： | 中原油田钻井工程技术研究院技术信息研究所,河南濮阳,457001 |
| |
| 摘 要： | 利用VBA语句编程,实现固定报表合并、动态报表合并、删除重复行空白行、打印报表上传情况及VBA与报表分离,结合Windows任务计划程序,分步、分模块直到实现生产日报表的定时自动生成。
|
| 关 键 词： | VBA编程 报表合并 任务计划程序 自动生成 |
Automatic Generation of Achieve Daily Production Reports with VBA Programming |
| |
| YANG Ting-fu
,
WANG Hui-mei.Automatic Generation of Achieve Daily Production Reports with VBA Programming[J].Computer Programming Skills & Maintenance,2012(20):23-25. |
| |
| Authors: | YANG Ting-fu WANG Hui-mei |
| |
| Affiliation: | (Institute for Technology information of the Drilling Technology Research Institute of ZhongYuan Oil field, He＇nan Puyang 457001, China) |
| |
| Abstract: | Fixed report amalgamation,dynamic report amalgamation,deleting repeated and blank line,printing report uploading status and separation of VBA and report are achieved with VBA language programming. Combined with Windows task plan program, taking steps and making module blocks are carried out until the daily production reports are timing automaticly generated. |
| |
| Keywords: | VBA programming report amalgamation task plan program automatic generation |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
