May 20 2022 02:28 AM - edited May 20 2022 02:30 AM
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(Sheet1.Range("f" & nxtR)), this seems not to do a trick. Any suggestion please?
May 20 2022 03:23 AM
May 20 2022 09:55 PM
@Hans Vogelaar didn't work. However, I worked my code around for solution.