我昨天就遇到了这个问题。而且还碰到下面两个问题:
1、ttr = Excel.Application.WorksheetFunction.VLookup(slidemaster.combobox1.text, [{ "六(1)","61班";"六(2)","62班"; "六(3)","63班";"七(1)","71班"; "七(2)","72班"; "八(1)","81班"; "八(2)","82班"; "九(1)","91班"; "九(2)","92班"}], 2, False)'
注:slidemaster.combobox1.list=Array("六(1)", "六(2)", "七(1)", "七(2)", "八(1)", "八(1)", "九(1)", "九(1)")
这个在powerpoint VBA有时能用,有时出错,极不稳定。简直百思不得其解。
2、sr=Excel.application.worksheetfunction.choose(N,sr1,sr2,sr3) 也是在powerpoint VBA使用,当sr1、sr2、sr3所代表的字符串较长长时,比如200多字时,时不时出错,也是极不稳定的,不是何故。
|