Public Sub F1_InRng(CurF1 As F1Book, ByVal CurtLine As Long, ByVal InCount As Long)
With CurF1
.InsertRange CurtLine + 1, -1, CurtLine + InCount, .MaxCol, F1ShiftRows
.MaxRow = .MaxRow + InCount
End With
End Sub
Dim ss As New CRPT_lgty
Dim sSQL As String
Dim s As String
sSQL = "Select * from sql离岗退养"
s = "{sql离岗退养.年} = " & nSysYear & " AND {sql离岗退养.月}= " & nSysMonth
MsgBox sSQL
Set rsRPT = cnData.Execute(sSQL)
' rsRPT.Open sSQL, cnData, adOpenKeyset, adLockBatchOptimistic
' ss.DiscardSavedData = True
ss.Database.SetDataSource rsRPT
ss.RecordSelectionFormula = s