+ Reply to Thread
Results 1 to 2 of 2

Copying files from a selected filepath to a filepath mentioned in a worksheet's cell

  1. #1
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Copying files from a selected filepath to a filepath mentioned in a worksheet's cell

    What I am trying to do is :
    • Have the VBA pgm ask the user the folder where the files are located
    • and have them copied to a file path mentioned in a cell



    Tried the following code:

    Please Login or Register  to view this content.
    Courtesy : Above code is a modified one found on http://www.rondebruin.nl/folder.htm





    Any help is much appreciated. thanks

    cross posted
    http://www.ozgrid.com/forum/showthre...446#post627446
    Last edited by subbby; 09-10-2012 at 03:58 PM. Reason: Solved

  2. #2
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Copying files from a selected filepath to a filepath mentioned in a worksheet's cell

    SOLVED IT :

    modified the code and had replaced a few lines with

    Please Login or Register  to view this content.
    Courtesy : http://en.allexperts.com/q/Excel-105...-Using-VBA.htm

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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