| 基于VBA对Excel 2007二次开发应用研究 |
| |
| 引用本文： | 刘铭.基于VBA对Excel 2007二次开发应用研究[J].现代电子技术,2010,33(10):55-57,62. |
| |
| 作者姓名： | 刘铭 |
| |
| 作者单位： | 重庆工程职业技术学院,重庆,400037 |
| |
| 摘 要： | Excel 2007在日常办公方面应用较普遍,但是在合并多个单元格时,只能保留选择区域最左上角的单元格数据,其他单元格的数据将被丢弃。针对工作中在合并单元格时,需要保留选择区域所有单元格的数据,在此提出基于VBA对Excel 2007二次开发,结合Excel 2007对象模型Application对象的属性,设计合并单元格控件的方法。在Windows XPSP3＋Office 2007环境下,设计并开发出控件,实现了合并多个单元格,保留选择区域数据,解决了工作中的实际问题。
|
| 关 键 词： | VBA 二次开发 Excel2007 合并单元格 |
VBA-based Secondary Development of Excel 2007 |
| |
| LIU Ming.VBA-based Secondary Development of Excel 2007[J].Modern Electronic Technique,2010,33(10):55-57,62. |
| |
| Authors: | LIU Ming |
| |
| Affiliation: | LIU Ming (Chongqing Vocational Institute of Engineering,Chongqing 400037,China) |
| |
| Abstract: | Excel 2007 has been widely applied in peoptes daily life,but there are also some problems.When merging multiple cells,just the cells on the very top left can be maintained and all the other cells are deleted.However,All the data of the cells in the selected area need be kept during the mergence of cells.The re-development of Excel 2007 is proposed based on VBA.The control widget of merging the cells is designed in combination with Excel 2007 objective mode and application object′s properties.Under the condition of Windows XP SP3＋Office 2007,the merging of multiple cells and the keeping of data in the selecting area are implemented by designing and developing control widget. |
| |
| Keywords: | VBA Excel 2007 |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
