練習取得資料夾名稱VBA:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub MAPI_FOLDER() | |
Dim myNameSpace As Outlook.NameSpace | |
Dim myFolder As Outlook.MAPIFolder | |
Dim C As Variant, arrC As Variant | |
arrC = Array(olFolderInbox, olFolderSentMail) | |
Set myNameSpace = Application.GetNamespace("MAPI") | |
For i = 0 To UBound(arrC) | |
Set myFolder = myNameSpace.GetDefaultFolder(arrC(i)) | |
MsgBox myFolder.Name | |
Call MAPI_subFolder_DEMO(arrC(i)) | |
Next | |
End Sub | |
Sub MAPI_subFolder_DEMO(C) | |
Dim subFolder As Outlook.MAPIFolder | |
Dim PATH As String | |
Dim subFolder_STR As String | |
Set myNameSpace = Application.GetNamespace("MAPI") | |
Set myFolder = myNameSpace.GetDefaultFolder(C) | |
MsgBox myFolder.Name | |
If myFolder.Folders.Count <> 0 Then | |
For Each subFolder In myFolder.Folders | |
MsgBox subFolder.Name | |
Next subFolder | |
Else | |
If myFolder.Folders.Count = 0 Then | |
MsgBox myFolder.Name | |
End If | |
End If | |
End Sub |
說明:
練習取得資料夾名稱
沒有留言:
張貼留言