| 用Vba实现大表格全自动分页小计汇总 |
| |
| 引用本文： | 王俊杰.用Vba实现大表格全自动分页小计汇总[J].黔东南民族职业技术学院学报,2006(3). |
| |
| 作者姓名： | 王俊杰 |
| |
| 作者单位： | 黔东南民族职业技术学院 贵州凯里556000 |
| |
| 摘 要： | 通过Vba编程,按照用户定义的每页行数,对Excel电子表格实现全自动分页,每页计算小计,表末计算总合计,设置表格重复打印表头,并以菜单或命令按钮举例说明程序调用方法。
|
| 关 键 词： | Vba编程 Excel表格 全自动分页小计 汇总 |
Realize full-automatic paging subtotal summary of big form with Vba |
| |
| Wang Junjie.Realize full-automatic paging subtotal summary of big form with Vba[J].Journal of Southeast Guizhou Vocational College of Technology for Nationalities(Comprehensive Edition),2006(3). |
| |
| Authors: | Wang Junjie |
| |
| Abstract: | Through Vba programming , walk and count according to page each that users defined , realizes full-automatic paging to Excel electronic form , page each calculate subtotal, form calculate total total the end, set up form print the gauge outfit repeatedly, and or order the button to illustrate the procedure with examples and transfer the method with the menu. |
| |
| Keywords: | Vba programming Excel Form full-automatic paging Subtotal summary |
| 本文献已被 CNKI 等数据库收录！ |
|
