hi professional
is there any macro to insert icon for each file based on extisions of files are existed in the headers . it should brings all of files under column contain extension . for instance if the header in column A contains PDF then should brings all of files contain PDF and put in column A with insert icon PDF in the same cell contain the file and when press the cell should open the file from this directory "c:\files\ this directory contain many folders contain many files . the same thing the others columns(B,C,D,E,F,G,H,I,J,K,L) contain DOCX,JPG,GIF,PNG,XLS,,XLSM,XLSX,AVI,WMV,MP4
BEFORE
AFTER
thanks
is there any macro to insert icon for each file based on extisions of files are existed in the headers . it should brings all of files under column contain extension . for instance if the header in column A contains PDF then should brings all of files contain PDF and put in column A with insert icon PDF in the same cell contain the file and when press the cell should open the file from this directory "c:\files\ this directory contain many folders contain many files . the same thing the others columns(B,C,D,E,F,G,H,I,J,K,L) contain DOCX,JPG,GIF,PNG,XLS,,XLSM,XLSX,AVI,WMV,MP4
BEFORE
AFTER
thanks