EXCEL选择多个工作表的VBA如何转成VFP
EXCEL选择多个工作表的VBA怎么转成VFP
excel 中选择多个工作的VBA 为:
Sheets(Array("Sheet1", "Sheet2", Sheet3", "Sheet4").Select
怎么换成VFP的代码呢?
我这样写 不成功:
local myarray(2) as array
myarray(1) = "Sheet1"
myarray(2) = "Sheet2"
loExcel.Sheets(myarray).Select
------解决方案--------------------
DIMENSION a1(2)
a1(1)='sheet1'
a1(2)='sheet2'
loExcel.Sheets(@a1).Select
excel 中选择多个工作的VBA 为:
Sheets(Array("Sheet1", "Sheet2", Sheet3", "Sheet4").Select
怎么换成VFP的代码呢?
我这样写 不成功:
local myarray(2) as array
myarray(1) = "Sheet1"
myarray(2) = "Sheet2"
loExcel.Sheets(myarray).Select
------解决方案--------------------
DIMENSION a1(2)
a1(1)='sheet1'
a1(2)='sheet2'
loExcel.Sheets(@a1).Select