摘要
利用VBA(Visual Basic for Application)对上报数据进行二次开发编程,实现将Excel数据批量自动填入全国工会帮扶数据管理系统新增临时救助档案页面中,并给出详细的实现过程。解决了手工输入速度慢、容易出错的问题,实现了网页表单内容的自动填写,具有界面友好,无需人工参与等特点,有很强的实用性和参考价值。
Using VBA(Visual Basic for Application),this paper carries out the secondary development programming on the reported data for realizing auto-filled Excel data into the new added page of interim relief in profile of the ACFTU aiding data management system,and gives the detailed implementation process.It solves the problems of manually slow input and error-prone,and realizes the auto-filled Web forms.With a friendly interface,without human intervention and so on,it is of a strong practical utility and referenced value.
出处
《计算机与现代化》
2013年第2期169-172,共4页
Computer and Modernization