+ Reply to Thread
Results 1 to 4 of 4

moving folders to one

  1. #1
    Registered User
    Join Date
    05-02-2009
    Location
    Tehran, IRAN
    MS-Off Ver
    Excel 2007
    Posts
    15

    moving folders to one

    hi, my problem is here:
    i am an economist and i have 8132 e-books in my hard. i save this e-books by ISBN-13digit. i want to move some books from a group to another, for example, from group "mathematics" to "statistics". i have a worksheet columnA contains ISBNs, columnB contains original path and columnC contains final path. how can i do that with a VBA. thanks

    ISBNsample.xlsx ORIGINAL PATH FINAL PATH
    9780195189629 E:\library\mathematics E:\library\statistics
    9780198288107 E:\library\mathematics E:\library\statistics



    9780262611343 E:\library\mathematics E:\library\statistics
    9780273655077 E:\library\mathematics E:\library\statistics

  2. #2
    Registered User
    Join Date
    05-02-2009
    Location
    Tehran, IRAN
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: moving folders to one

    also i must mention that column A contains "folder" names that is ISBN-13digit no files. sincerely

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: moving folders to one

    See attached sample file.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-02-2009
    Location
    Tehran, IRAN
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: moving folders to one

    thanks a lot, it works

+ 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. Moving like named files into folders with same name
    By oybombadil in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2015, 08:22 AM
  2. moving quarter files to folders
    By saratu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2014, 11:55 AM
  3. Moving file between folders error (FSO)
    By milo1984 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-04-2013, 04:42 PM
  4. Will moving folders mess up formula?
    By welshman010 in forum Excel General
    Replies: 6
    Last Post: 09-06-2008, 08:04 PM
  5. [SOLVED] Moving workbooks between folders
    By Ozzie in forum Excel General
    Replies: 3
    Last Post: 01-25-2006, 05:30 AM
  6. Moving files between folders using VBA in Excel
    By Paul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2005, 10:05 AM
  7. [SOLVED] Excel VBA: moving folders on the server
    By Myrna Rodriguez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2005, 09:06 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