Dear Experts,
I currently encounter a problem on how to use DIR to open the specific files from a folder :
1. The file names in the folder is "ProjectCode-YearMonth-Flex.xlsm"
2. ProjectCode is a 5 digit number, and there are many ProjectCode files in the folder
3. Example for the file name is 03028-201909-Flex.xlsm
4. My VBA is basically to open each ProjectCode file and perform some action
The codes just finish to the end without opening any files however hard I tried to modify, which I believe is due to syntax error in the DIR line
Grateful if anyone could help.
Many thanks.
Bookmarks