PDA

View Full Version : Loop excel files and sort it in a tree diagram



Afandi1992
12-29-2015, 07:48 AM
Hye, I need help to solve my problem here. I got a situation where there are 3 file in a folder and i want it to tell the user which one first and sort it it a tree diagram. The macro will open the file and see if the number stated inside the file. For example the output macro in the jpg image i stated below.

Hope you guys can help me. Thank you.

Regards,
Afandi.

Here i attach the example 3 file.