6/1/2023 0 Comments Vba get file pathSo, this was all about VBA DIR Function in Excel. There also might be an easier way I couldnt find while searching. I think I found something that can get it but the example is just different enough I cant figure it out and I dont have time to play with it. Later it recursively calls the ‘ Enlist_Directories’ function to retrieve the file names. Im looking to get the file path of a selected part/assembly while inside of an assembly. Worksheets(lngSheet).Cells(ActiveCell.Row 1, 1).ActivateĬall Enlist_Directories(strFldrList(x), lngSheet)Įxplanation: This code first iterates through all the folders present inside a location and stores them in an array. StrFldrList(lngArrayMax) = strPath
0 Comments
Leave a Reply. |