Notice
Recent Posts
Recent Comments
목록CreateObject (1)
rand(life)
[vba] 특정 폴더의 하위 폴더 이름 가져오기
CreateObject("Scripting.FileSystemObject") 를 이용하는 방법이다. (파란색 글씨가 핵심 부분이다) 출처: https://stackoverflow.com/ Option Explicit Public Arr() As String Public Counter As Long Sub macro() Dim myArr strPath = "d:\data\" myArr = GetSubFolders(strPath)Counter = 0 End Sub Function GetSubFolders(RootPath As String) Dim fso As Object Dim fld As Object Dim sf As Object Dim myArr Set fso = CreateObject("Scriptin..
컴퓨터/엑셀
2017. 7. 19. 21:46