12-20-2016, 08:18 PM
With recording keys/mouse maybe possible but will be very slow for 12000.
With coding:
Macro Macro2746
With coding:
Macro Macro2746
;This macro takes the selected range from Excel (can be whole column selected or just part),
;and creates folders using names from the selected cells.
str where="D:\Test" ;;change this
ExcelSheet e.Init
ARRAY(str) a; int i
e.CellsToArray(a "sel")
for i 0 a.len
,str path=F"{where}\{a[0 i]}"
,out path
,;mkdir path ;;uncomment this when this macro is ready to create folders