Dim xlapp As Object
Set xlapp = CreateObject("excel.application")
Dim i As Long
xlapp.Application.Visible = True
Set xlbook = xlapp.workbooks.Open(CurrentProject.Path & "\Master List for Records.xls")
????
Next
Set xlapp = Nothing
End Sub 作者: bshchangss 时间: 2012-1-10 23:48 本帖最后由 bshchangss 于 2012-1-10 23:50 编辑
另外,我想问问下面这句是什么意思?
For i = 1 To Me.history.Form.RecordsetClone.RecordCount
我想要复制上面这句加以修改,变成对应窗体里的另一个子窗体,但不是简单的把窗体名改掉就可以,我把它改为下面这样:
For i = 1 To Me.defectrecord.Form.RecordsetClone.RecordCount
就会提示我"For变量已在使用",应该怎么修改啊?
{:soso_e101:}作者: Henry D. Sy 时间: 2012-1-11 00:47
Me.defectrecord.Form.RecordsetClone.RecordCount
当前窗体defectrecord子窗体的记录数作者: roych 时间: 2012-1-11 00:57
bshchangss 发表于 2012-1-10 23:48
另外,我想问问下面这句是什么意思?
For i = 1 To Me.history.Form.RecordsetClone.RecordCount
我想要复 ...