2020-05-25から1日間の記事一覧
Sub フォルダ内のサブフォルダ一覧を取得する() Dim objFso As Object Set objFso = CreateObject("Scripting.FileSystemObject") Dim objFolder As Object Set objFolder = objFso.GetFolder(ThisWorkbook.Path) Dim f As Object For Each f In objFolder.S…
Sub フォルダ内のサブフォルダ一覧を取得する() Dim objFso As Object Set objFso = CreateObject("Scripting.FileSystemObject") Dim objFolder As Object Set objFolder = objFso.GetFolder(ThisWorkbook.Path) Dim f As Object For Each f In objFolder.S…