Hi all:
I want macro to check all file name in folder, if file name similar (different one or two charactor) will create new folder "OLD" then remove file with number smaller to folder "OLD"
Example: Folder have:
G03144-99201001-01201001-201906-BI-M-01.xlsx
G03144-99201001-01201001-201906-BI-M-02.xlsx
G03144-99201001-01201001-201906-BI-M-05.xlsx
G03144-99201001-01201001-201906-BI-M-10.xlsx
G03144-99201001-01201001-201906-BI-M-15.xlsx
=> Create Folder "OLD" and remove G03144-99201001-01201001-201906-BI-M-01.xlsx, G03144-99201001-01201001-201906-BI-M-02.xlsx, G03144-99201001-01201001-201906-BI-M-05.xlsx, G03144-99201001-01201001-201906-BI-M-10.xlsx
Folder only have: G03144-99201001-01201001-201906-BI-M-15.xlsx
Thanks./.
I want macro to check all file name in folder, if file name similar (different one or two charactor) will create new folder "OLD" then remove file with number smaller to folder "OLD"
Example: Folder have:
G03144-99201001-01201001-201906-BI-M-01.xlsx
G03144-99201001-01201001-201906-BI-M-02.xlsx
G03144-99201001-01201001-201906-BI-M-05.xlsx
G03144-99201001-01201001-201906-BI-M-10.xlsx
G03144-99201001-01201001-201906-BI-M-15.xlsx
=> Create Folder "OLD" and remove G03144-99201001-01201001-201906-BI-M-01.xlsx, G03144-99201001-01201001-201906-BI-M-02.xlsx, G03144-99201001-01201001-201906-BI-M-05.xlsx, G03144-99201001-01201001-201906-BI-M-10.xlsx
Folder only have: G03144-99201001-01201001-201906-BI-M-15.xlsx
Thanks./.