Forum Discussion

Rob233's avatar
Rob233
Copper Contributor
May 20, 2022

File system objects VBA

If I am looping through a sub folder and I'd like to change folder path like: Dim fol As Scripting.folder 'if Sheet1.Range("f" & nxtR) is listed path on a cell (range). Set fol = FSO.GetFolder(She...
Macros and VBA
HansVogelaar's avatar
HansVogelaar
MVP
May 20, 2022

Rob233 

Does this work?

 

Set fol = FSO.GetFolder(Worksheets("Sheet1").Range("F" & nxtR).Value)

  • Rob233's avatar
    Rob233
    Copper Contributor
    May 21, 2022

    HansVogelaar didn't work. However, I worked my code around for solution.

Resources