Closed Thread
Results 1 to 4 of 4

Move files based in excel data

  1. #1
    Registered User
    Join Date
    09-30-2008
    Location
    USA
    MS-Off Ver
    2010
    Posts
    36

    Move files based in excel data

    Hello,

    I need help in coding this task please. I'm really new to VBA.

    I have a column in a excel file with the image of products, like this:

    COLUMN D
    SM5603.jpg
    HT82564.gif
    HT45334.gif
    NW4533.jpg
    NW93433.jpg

    I also have a folder of images where are located the images of the products listed in the excel file. Because there are thousands of images on this folder, I need to automatically move to another folder only the images that are mentioned in the excel file.

    Could anyone help me on this please?

    Thanks in advance!!!
    Greg

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Move files based in excel data

    This would have been better placed in the Programming Forum.

    Try this, be sure to edit the two PATH variable strings to your folders:
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    09-30-2008
    Location
    USA
    MS-Off Ver
    2010
    Posts
    36

    Re: Move files based in excel data

    JBeaucaire,
    Thank you for your help. Now I can move my images, but also, I can see what images are missed. You did it great!
    Thanks!!!

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Move files based in excel data

    If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

Closed 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