Excel精英培训网

 找回密码
 注册

可以引用EXCEL数据,简写脚本吗?

已有 1014 次阅读2016-5-23 20:52 | 按键精灵, EXCEL

网址:http://202.105.30.26:8088/opac/servlet/opac.go
以下是我写的脚本,红体字是引用EXCEL里的数据,这个脚本可以简写吗?可以让按键精灵引用EXCEL数据,无须写得如此长吗?
类似VBA里面的数组之类,或FOR NEXT之类。
ProcessID = Plugin.Web.Bind("WQM.exe")
Delay 500
Call Plugin.Web.HtmlSelect("TITLE", "name:FIELD1")
Delay 1500
Call Plugin.Web.HtmlSelect("AUTHOR", "name:FIELD1")
Delay 1500
Call Plugin.Web.HtmlSelect("CLASSNO", "name:FIELD1")
Delay 1500
Call Plugin.Web.HtmlSelect("SUBJECT", "name:FIELD1")
Delay 1500
Call Plugin.Web.HtmlSelect("ISBN.010$a", "name:FIELD1")
Delay 1500
Call Plugin.Web.HtmlSelect("ISBN.011$a", "name:FIELD1")
Delay 1500
Call Plugin.Web.HtmlSelect("UNIONNO", "name:FIELD1")
Delay 1500

TITLE 题名
AUTHOR 责任者
CLASSNO 分类号
SUBJECT 主题词
ISBN.010$a ISBN
ISBN.011$a ISSN
UNIONNO 统一刊号


评论 (0 个评论)

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-6-26 11:52 , Processed in 0.286540 second(s), 5 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

返回顶部