+ Reply to Thread
Results 1 to 3 of 3

Moving Files based on user input to choose destination

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    Australia
    MS-Off Ver
    Excel 2002
    Posts
    2

    Moving Files based on user input to choose destination

    Hello. I'm using Excel 2002 on a PC.

    I'll keep this as brief as possible.

    I want to move the contents of a folder [containing various filetypes] to another folder, based on user input.
    i.e.
    On C: drive I have folders called day1, day2, day3
    On D drive I have folders called archive1, archive2, archive3

    So I want the user to be posed the question 'Which day to move?'. In this case if the user input '1' the files would be moved from day1 to archive1.

    All the folders in question already exist. Ideally this could move the contents of more than one folder at a time i.e. if the user input '1' the contents of folders day1 and night1 would be moved.

    Any help will be greatly appreciated, and thanks in advance.

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

    Re: Moving Files based on user input to choose destination

    http://www.rondebruin.nl/folder.htm
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    08-23-2012
    Location
    Australia
    MS-Off Ver
    Excel 2002
    Posts
    2

    Re: Moving Files based on user input to choose destination

    Much appreciated patel45, but I've done a few searches and found that page earlier. There is no code in those examples that collects input from the user, the paths are written into the macros and you have to change them every time.

+ 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