+ Reply to Thread
Results 1 to 2 of 2

Macro to concatenate file name

  1. #1
    Registered User
    Join Date
    07-30-2019
    Location
    India
    MS-Off Ver
    2016
    Posts
    11

    Macro to concatenate file name

    Hi All,

    ID PPNo PPRev PPType ATPno
    710032768145 100052 37 CU 94060734
    710032568145 101742 17 CU 94060734
    710032761928 101788 23 CU 94074501
    710034561928 101789 21 CU CON 570341
    810032761998 101814 19 CU CON 570341
    910032761929 102060 8 CU CON 570341
    710032760058 102580 16 CU 94070293

    In a folder I have files with ATPno as below
    94060734.pdf
    94074501.pdf
    CON 570341.pdf
    94070293.pdf
    now the task is like if ATPno column has the file linked to different ID in column A, but I have only one file in folder, is there any way like I copy the file 94060734.pdf and get another copy and rename that new file to 710032568145_94060734.pdf and in folder I should have 2 pdf files as below
    710032768145_94060734.pdf
    710032568145_94060734.pdf

    can any one help me out on this. TIA

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,135

    Re: Macro to concatenate file name

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

+ 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. [SOLVED] Concatenate using macros and do vlookup into .xlsm file
    By pacificepoc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2018, 04:12 AM
  2. File Path - Concatenate
    By TomWhipps in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2015, 07:18 AM
  3. Insert CONCATENATE-generated file path into IF formula
    By feclips in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2013, 04:35 AM
  4. Replies: 8
    Last Post: 11-12-2012, 02:39 PM
  5. Formula to calculate sum with file referenced in cell (similar to CONCATENATE)
    By ggremel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-27-2011, 07:14 PM
  6. Dynamically referencing file in concatenate
    By coryg in forum Excel General
    Replies: 2
    Last Post: 10-05-2010, 02:12 PM
  7. Concatenate to a text file
    By NewGuy100 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2005, 02:05 PM

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