Results 1 to 8 of 8

Need macro to copy files (full path list) to another directory

Threaded View

jhren Need macro to copy files... 07-10-2015, 07:59 PM
JBeaucaire Re: Need macro to copy files... 07-11-2015, 12:55 AM
JBeaucaire Re: Need macro to copy files... 07-11-2015, 12:56 AM
jhren Re: Need macro to copy files... 07-11-2015, 10:46 AM
JBeaucaire Re: Need macro to copy files... 07-11-2015, 10:51 AM
jhren Re: Need macro to copy files... 07-11-2015, 11:05 AM
JBeaucaire Re: Need macro to copy files... 07-11-2015, 11:11 AM
jhren Re: Need macro to copy files... 07-11-2015, 11:18 AM
  1. #5
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need macro to copy files (full path list) to another directory

    Can you post the full filenames of a couple that didn't work. It has not been my experience that the DIR method is affected by special characters, if they are allowed then the DIR() call can see them and thus can use them. I'll take a look at your examples.

    Sorry, COPY, not move.
                fNAME = Right(f.Value, Len(f.Value) - InStrRev(f.Value, Delim))
                FileCopy f.Value, destPATH & fNAME
                f.Offset(, 1).Value = "Copied"


    FYI, AC/DC is not an accepted special character. The / is a network path separator and will always cause problems in my experience.
    Last edited by JBeaucaire; 07-11-2015 at 10:53 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding full file path from list of files in excel
    By fletch82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2014, 08:45 AM
  2. Macro to get list of all files in directory
    By boss1982 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-21-2013, 03:18 PM
  3. Return full file path for files in directory
    By jeffreybrown in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2011, 12:42 PM
  4. [SOLVED] Show full path of files being saved
    By JERRY in forum Excel General
    Replies: 4
    Last Post: 05-16-2006, 03:10 PM
  5. Linking files with variable directory path
    By gase05@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2005, 08:05 AM

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