+ Reply to Thread
Results 1 to 3 of 3

Loop excel files and sort it in a tree diagram

  1. #1
    Registered User
    Join Date
    12-23-2015
    Location
    Malaysia
    MS-Off Ver
    2007
    Posts
    16

    Loop excel files and sort it in a tree diagram

    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.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-09-2015
    Location
    India
    MS-Off Ver
    2010
    Posts
    65

    Re: Loop excel files and sort it in a tree diagram

    Hi Afandi1992,

    i understood your question but i want to know what output you want from the macro. i want to know what outcome you want from the macro code. Please let us know what output you are looking for ? so that we can share the appropriate code.

    Regards
    Ramandeep Singh

  3. #3
    Registered User
    Join Date
    12-23-2015
    Location
    Malaysia
    MS-Off Ver
    2007
    Posts
    16

    Re: Loop excel files and sort it in a tree diagram

    Hi raman1667,

    The output just like in the image i have shown. It can be either save in a new workbook or just in a notepad to show to the user.

    Thank you.

    Regards,
    Afandi

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VB Code to open excel files in a loop
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2015, 05:35 PM
  2. [SOLVED] Excel Diagram: bubble diagram with dynamic quadrants
    By meiselsan in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-27-2015, 08:26 AM
  3. [SOLVED] Transforming 1level coded product tree to few level product tree
    By Gukupozu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2015, 10:31 AM
  4. Creating a tree diagram from a 5-column matrix
    By phrankndonna in forum Excel General
    Replies: 4
    Last Post: 05-13-2014, 08:59 AM
  5. Replies: 5
    Last Post: 11-19-2013, 04:11 PM
  6. Populate a 'Tree diagram' with x variables quickly.
    By alkj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2013, 11:28 AM
  7. Macro Loop Create Excel Files
    By gsurge in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-15-2011, 04:28 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1