VBAでPythonのGlob方式でファイルを検索するためのクラスを作成してみた - Qiita

VBAでPythonのGlob方式でファイルを検索するためのクラスを作成してみた - Qiita

Private DefPath As String Private Items As Variant Private FSO As Object Enum GlobDataType None =...概要を表示 Private DefPath As String Private Items As Variant Private FSO As Object Enum GlobDataType None = 0 StringArray = 1 ArrayList = 2 dictionary = 3 Collection = 4 End Enum Private Sub Class_Initialize() Set FSO = CreateObject("Scripting.FileSystemObject") With CreateObject("WScript.Shell") .CurrentDirectory = ThisWorkbook.path & "\" End With Me.Clear End Sub Private Sub Class_Terminate() Set Items =