è¿ä¸ªé®é¢æ¶åå°å¯¹excel对象çæ§å¶åADODBï¼ADOï¼å¯¹è±¡ç使ç¨ã
å¦æä¸çæexcelä¸çvbaå¯ä»¥ç¾åº¦ä¸ä¸ï¼ä¸»è¦æ路就æ¯å¾ªç¯è¯»åè¡¨æ ¼æ°æ®å°æ°æ®æ§ä»¶ã
以ä¸ç¤ºä¾ä»ç»å¦ä½æ·»å è®°å½å°Recordset 对象ã
'VB6éæ©âå·¥ç¨âèåçâå¼ç¨âï¼ç¶åæ·»å 对 Microsoft ActiveX Data Objects 2.0 Library çå¼ç¨ã
' å建 Recordset çä¸ä¸ªå®ä¾ã
Set rs = New ADODB.Recordset
' 设置 Recordset çå±æ§ï¼è¿éæ¯ä¸¤ä¸ªå段ï¼ã
With rs
.Fields.Append "DirID", adInteger
.Fields.Append "Directory", adBSTR, 255
.CursorType = adOpenStatic
.LockType = adLockOptimistic
.Open
End With
' å¨åç®å½ä¸å¾ªç¯ï¼å¹¶å
å¡«Recordset
strPath = "C:\"
strName = Dir(strPath, vbDirectory)
i = 0
Do While strName <> ""
If strName <> "." And strName <> ".." Then
If (GetAttr(strPath & strName) And _
vbDirectory) = vbDirectory Then
i = i + 1
With rs
.AddNew 'æ·»å æ°çè®°å½
.Fields.Item("DirID") = i
.Fields.Item("Directory") = strName
.Update
End With
End If
End If
strName = Dir
Loop
' è¿åå°ç¬¬ä¸ä¸ªè®°å½ã
rs.MoveFirstæ¥èªï¼æ±å©å¾å°çåç