Excel精英培训网

 找回密码
 注册

循环输入

已有 598 次阅读2016-6-9 10:09

text = Plugin.File.ReadFileEx("C:\Users\haier\Desktop\1.txt")
arr = split(text, "|")

For i = 0 To 41 Step 10
Delay 100
SayString arr(i)
Delay 500
KeyPress "Enter", 1
SayString arr(i+1)
Delay 500
KeyPress "Enter", 1
SayString arr(i + 6)
KeyPress "Enter", 1
Next

 

Sub celia(i)
text = Plugin.File.ReadFileEx("C:\Users\haier\Desktop\1.txt")
arr = split(text, "|")
KeyPress arr(i), 1
End Sub
For i = 0 To 8 step 2
 Delay 500
     Call celia(i+1)
     Delay 500
Next

评论 (0 个评论)

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

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

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

返回顶部