Cakz Primz
Board Regular
- Joined
- Dec 4, 2016
- Messages
- 102
- Office Version
- 365
- Platform
- Windows
Dear all,
I have a folder name Punch and subfolder year (2021, 2022 etc), and in subfolder year I have subfolder of month (01. Jan, 02. Feb, 10. Oct etc) and in subfolder month, I have subfolder of date from 1 till 31 (01, 02, 03, 29, 30, 31).
And the file name I need to open is: AXREP.xlsb
Is it possible dynamically opening this file within that nested folder and subfolder.
For the moment the latest year is: 2022, and the latest month is: 10. Oct, and the latest date is 28
C:\Punch\2022\10. Oct\28\AXREP.xlsb
Thank you in advance.
Prima Indonesia
I have a folder name Punch and subfolder year (2021, 2022 etc), and in subfolder year I have subfolder of month (01. Jan, 02. Feb, 10. Oct etc) and in subfolder month, I have subfolder of date from 1 till 31 (01, 02, 03, 29, 30, 31).
And the file name I need to open is: AXREP.xlsb
Is it possible dynamically opening this file within that nested folder and subfolder.
For the moment the latest year is: 2022, and the latest month is: 10. Oct, and the latest date is 28
C:\Punch\2022\10. Oct\28\AXREP.xlsb
Thank you in advance.
Prima Indonesia