| 利用VBA实现网页中自动录入成绩 |
| |
| 引用本文： | 江治. 利用VBA实现网页中自动录入成绩[J]. 安庆师范学院学报(自然科学版), 2010, 16(3): 124-127. DOI: 10.3969/j.issn.1007-4260.2010.03.037 |
| |
| 作者姓名： | 江治 |
| |
| 作者单位： | 华东师范大学,信息科学技术学院,上海,200241;温州大学,物理与电子信息工程学院,浙江,温州,325035 |
| |
| 摘 要： | VBA是Office系列软件内嵌的通用编程语言,用于定制和扩展Office的功能。本文利用Excel中的VBA进行二次开发编程,实现了将保存在Excel文件中的成绩自动录入到信息管理系统登记成绩的页面的功能,并给出了详细的实现过程。该程序操作简便,自动录入迅速,解决了教师手工输入速度慢且容易出错的问题,具有一定的实用价值。
|
| 关 键 词： | VBA OLE 自动录入 |
Register Result in the Webpage Automatically by Using VBA |
| |
| JIANG Zhi. Register Result in the Webpage Automatically by Using VBA[J]. Journal of Anqing Teachers College(Natural Science Edition), 2010, 16(3): 124-127. DOI: 10.3969/j.issn.1007-4260.2010.03.037 |
| |
| Authors: | JIANG Zhi |
| |
| Affiliation: | JIANG Zhi(East China Normal University,College of Information Science , Technology,Master of Science,Shanghai,200241,Wenzhou University,College of Physics & Electronic Information Engineering,Zhejiang 325035) |
| |
| Abstract: | VBA is a common programming language embedded in Office,which is used to customize and expand the functions of Office.In this article,the author uses VBA in Excel to redevelop programming,which achieves the function of inputting automatically the results saved in the Excel files into the page for results registration in the Information Management System,and the author also explains how the process is achieved in details.The program is simple and rapid in automatic input,solving the problems such as slowness... |
| |
| Keywords: | VBA OLE |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
