+ Reply to Thread
Results 1 to 7 of 7

copying images from one folder and pasting in another based on schedule in excel file

  1. #1
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    copying images from one folder and pasting in another based on schedule in excel file

    Hi, im in a situation where i have a list of product codes which i need to download images for and a folder that has over 5000 photos in. im not sure if the folder has certain images that are in my product list. If i have product codes in Column A and Column B should read copied (if there was a file with the same name in the folder of 5000 photos) or missing (if the folder does not have the file)
    folder 1 is the folder with the 5000 images
    folder 2 should be the folder where the image should be copied to.

    can a macro be written to do this automatically by scanning the product codes and scanning the folder1 and copying the images across to folder 2

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

    Re: copying images from one folder and pasting in another based on schedule in excel file

    yes, attach please a sample file with notes
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: copying images from one folder and pasting in another based on schedule in excel file

    here is an example of what i want to be done example.xlsx

  4. #4
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: copying images from one folder and pasting in another based on schedule in excel file

    here is the example

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

    Re: copying images from one folder and pasting in another based on schedule in excel file

    put C:\Images\ in B2 and C:\supplier1\ in C2 then run this code

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: copying images from one folder and pasting in another based on schedule in excel file

    AWESOME :D Thanks allot @patel45 you are a genius of note

  7. #7
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: copying images from one folder and pasting in another based on schedule in excel file

    Hi @patel45. hope you keeping well and knocking out the park the awesome coding you provide.
    just wanted to find out if you can assist again on the above code. lets say for instance i want to put more than 1 image name in the row, eg. "image1.jpg;image2.jpg", and i want both these images to be copied to the folder, can that be done? ive attached a sample of
    Attached Files Attached Files
    Last edited by merQrey; 07-24-2020 at 03:58 AM. Reason: want to attach sample.

+ 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. Macro for copying from excel and pasting into word file
    By kitcargray in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2012, 06:03 PM
  2. Macro for copying specific data from excel files in a folder to a newly created excel file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2012, 02:24 PM
  3. Replies: 1
    Last Post: 04-03-2012, 02:02 PM
  4. Copying images from excel to the end of a word file
    By bagullo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2012, 12:06 PM
  5. Replies: 1
    Last Post: 08-20-2010, 11:12 PM

Tags for this Thread

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