+ Reply to Thread
Results 1 to 5 of 5

Copy files from one folder to another folder (path in textbox)

  1. #1
    Registered User
    Join Date
    09-23-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    33

    Talking Copy files from one folder to another folder (path in textbox)

    I have 3 database. Database1 (C is my personal database. Database2 (D is a worldwide shared database which is very slow. and lastly Database3 (J which is a mirror of "D:" for viewing purposes only (cannot copy nor paste in this database). To copy a file from D: to C: what I normally do is go to J: first ,as this drive is 100x faster than D:, to search the files I want to copy. Once I find my target files, I copy the path from J then open that path in D: Drive (e.g., Copy J:\Gelatine\Sugar\Baby.xls and paste in D: Drive as D:\Gelatine\Sugar\Baby.xls) which takes several minutes to load. Once D: Drive is open, I can now copy the file from D to C. (take note J drive is for viewing purposes only.).

    What I want to achieve is to make a UI/Userform with 2 textbox and 1 button. Textbox1 is where the user will put the path from J: and textbox2 is the path where the user wants to save the target files from J. Once the button is pressed, this will automatically save the files from J/D to C.

    Is this possible?

    I am not really sure what vba codes to use.

    Please help. Thanks.

    Thanks.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Copy files from one folder to another folder (path in textbox)

    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    10-19-2013
    Location
    Germany
    MS-Off Ver
    Excel 2003
    Posts
    1

    Thumbs up Re: Copy files from one folder to another folder (path in textbox)

    I faced the same problem as you trying to Copy files from one folder to another folder and I was adviced by a friend to try long path tool and it's really work well for me , Now I'm able to copy / delete path files without any problems .

    edenrol

  4. #4
    Registered User
    Join Date
    05-11-2014
    MS-Off Ver
    Excel 2003
    Posts
    1

    Long path tool

    You can try Long path tool for best result.

  5. #5
    Registered User
    Join Date
    06-24-2014
    Location
    asdf
    MS-Off Ver
    \
    Posts
    1

    Re: Copy files from one folder to another folder (path in textbox)

    The best solution to ur problem I m sure is u must try DuplicateFilesDeleter ....


    I am sure DuplicateFilesDeleter will help you out ....

+ 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] VBA Code open files in folder, copy text to workbook-Next time folder opened copy only new
    By Bikeman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2013, 07:59 PM
  2. List folder path according to folder index
    By naflas in forum Excel General
    Replies: 4
    Last Post: 07-15-2010, 07:33 PM
  3. How to find files in a folder and write the path to the spreadsheet
    By KrNpRiDe in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-25-2009, 06:59 PM
  4. Finding the Path to the Program Files Folder
    By JGS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2005, 05:19 AM
  5. How to copy 30 csv files from a folder to another folder
    By ddiicc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2005, 05: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