+ Reply to Thread
Results 1 to 1 of 1

Search for a value and rename a folder in a specific path with its adjacent value

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Search for a value and rename a folder in a specific path with its adjacent value

    Hi friends,

    I have command button in an excel sheet, for which i have created VBA code. When this button is pressed, it looks for values in Column H and compare it with column B, if these values are found in column B, it will rename a folder in a specific path(path given below) with the values adjacent to it in column A. While renaming the folder it keeps cell E2 value first and then A column value

    Path: C:\Users\engr_\Desktop\Test\ (here folders are kept with names of data in column H) screen shots are also given.

    Sheet is also attached for reference.

    THE ISSUE IS IT ONLY RENAMES WITH THE FIRST DATA OF COLUMN A, IT SHOULD RENAME WITH ADJACENT VALUE ANY NUMBER FOUND. NEED HELP PLEASE

    1.PNG
    2.PNG

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Zahid0111; 08-13-2021 at 01:12 PM.

+ 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. Search for a folder and get folder path using VBA
    By demarc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-03-2019, 05:27 AM
  2. VBA to Search Folder Path with spaces
    By Turneron2wheels in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2015, 04:29 AM
  3. How to Rename the files extension in a Specific Folder
    By Kandavalli.Kiran in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 04-26-2015, 08:36 AM
  4. copy a file several times, rename it and place in a specific folder
    By exceliscool in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2013, 07:35 AM
  5. Code to list the folder path and sub folder path of a specific file
    By kalai1587 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2013, 03:51 AM
  6. search and open folder even if Path changes
    By Desmond_Mocumi in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-05-2013, 02:48 AM
  7. Search for folder rename & move from cell reference
    By formatt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2012, 01:49 AM

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