I have a directory which goes to the folder \\asiapac.ad.company.com\home2\fdgg\4546567\Desk\Desktop\Alteryx Review\07\Event Diary.xlsx
I want to access all the folders in this link \\asiapac.ad.company.com\home2\fdgg\4546567\Desk\Desktop\Alteryx Review
There could be a formula to eliminate character after Alteryx Review and then I guess macros would be required?
Any help is appreciated