Posts by ixladxi

    Re: Macro Help


    No reason for using code except I thought it had to be done that way. This is for a list of numbers.


    Input Column is
    123456
    654321



    Desired Output Column is
    AC_VOLUME_4:Assets:HR Images:1:12:123:123456.PSD
    AC_VOLUME_4:Assets:HR Images:6:65:654:654321.PSD


    Does that make more sense?

    Is there a way to create a macro that creates

    "AC_VOLUME_4:Assets:HR Images:7:75:752:752388_V1.PSD"

    in column B from

    "752388_V1"

    in column A?

    “AC_VOLUME_4:Assets:HR Images:” is standardized. The rest of the file path is based off the file name. The folder structure is always broken down to the first (3) digits of the file name.

    Thank your help in advance.

    Jeff
    [TABLE="width: 836"]

    [tr]


    [td][/td]


    [/tr]


    [/TABLE]