Results 1 to 5 of 5

Thread: To explain the macro-enabled working in a file

  1. #1

    To explain the macro-enabled working in a file

    Register for a FREE account, and/
    or Log in to avoid these ads!

    A person has sent to me a file which is macro-enabled file.Can anybody help me to understand the file step-by-step that how has he worked out in this file?I am unable to self understand the working of that file.
    For more clarification,please refer the attach file.

    Attached Files Attached Files

  2. #2
    It simply reformats the data from multiple lines per part number, and spits it out to a new worksheet with part number on one line, all of its suppliers in adjacent columns.

  3. #3
    I want to know the working steps involved in this file.Can you explain me in details of the steps by steps working?

    Thanks in advance.

    Pradeep Kumar Gupta

  4. #4
    It creates a dictionary object and adds each Part Code to that dictionary. As it processes each Part it checks if it is in the dictionary, if not, it adds it and its supplier, if it does it just appends the supplier to that dictionary part item.

    Then it dumps the dictionary items into an array, loops the array and splits each element into its component parts and loops through those dropping them all into a single row.

    The last loop can be done in a single statement, without the loop.

  5. #5
    Thanks for your solution.

    Pradeep Kumar Gupta

Posting Permissions

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