各位专家:
我想在特定加载后的当前表中,所用行的“确认列”(逻辑型),自动 = True,代码怎么写?
以下是我的代码,但是报错:
Dim StartDate As Date
Dim EndDate As Date
With RibbonTabs("业务管理")("查询")("时间筛选")
StartDate =
.Items("StartDate").Value
End With
With RibbonTabs("业务管理")("查询")
EndDate = .Items("EndDate").Value
End With
DataTables("结算表").LoadFilter
= "[日期] >= #" &
StartDate &
"# And [日期] <= #" & EndDate & "#"
DataTables("结算表").Load()
With Tables("结算表")
.Cols("确认") = True
End With