| 使用VBA统计Excel中字符个数 |
| |
| 引用本文： | 张焱,张金宝.使用VBA统计Excel中字符个数[J].电脑与信息技术,2011,19(4):72-75. |
| |
| 作者姓名： | 张焱 张金宝 |
| |
| 作者单位： | 交通运输部管理干部学院,河北廊坊,065201 |
| |
| 摘 要： | 通过菜单操作，统计Excel文中字数非常麻烦，而借助ExcelVBA可方便快捷的统计单个Excel文件的字符个数、多个Excel文件的字符个数。将所有需统计的Excel文件放到一个文件夹下，使用文中提供的程序即可完成字数统计，并能将含有文件名及对应字符个数的统计结果存放到Excel文件中。
|
| 关 键 词： | Excel Excel VBA 统计字符个数 |
Counting Number of Characters in Excel Files by Excel VBA |
| |
| ZHANG Yan,ZHANG Jin-bao.Counting Number of Characters in Excel Files by Excel VBA[J].Computer and Information Technology,2011,19(4):72-75. |
| |
| Authors: | ZHANG Yan ZHANG Jin-bao |
| |
| Affiliation: | ZHANG Yan,ZHANG Jin-bao (Management Institute of Ministry of Transport of the People's Republic of China,Lang Fang 065201,China) |
| |
| Abstract: | Through menu operation, counting text words in Excel is very difficult, and statistics the total number of characters by using Excel VBA can be convenient in a single Excel file and multiple Excel files. All the required operation is gathering Excel files |
| |
| Keywords: | Excel Excel VBA words count |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
