+ Reply to Thread
Results 1 to 10 of 10

How Do Extract All Images From A Excel Spreadsheet All At Once Into A Folder?

  1. #1
    Registered User
    Join Date
    09-21-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011
    Posts
    13

    Question How Do Extract All Images From A Excel Spreadsheet All At Once Into A Folder?

    Hi Guys,

    I have about 40 Spread sheets that all contain many images that I need to upload to a website. How can I do this with out having to click “save picture” for every single image? Anyone who could help me with this – it would be extremely appreciated.
    Please try to explain it to me in “Dummy” Terms; I’m not too advanced in Excel Yet. I am also using a Mac if that makes any difference but I doubt it.

    Thank You In Advance!!!

  2. #2
    Registered User
    Join Date
    09-21-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011
    Posts
    13

    Re: How Do Extract All Images From A Excel Spreadsheet All At Once Into A Folder?

    Anyone? Im in desperate need of this help, I have to somehow finish this by tonight...

  3. #3
    Registered User
    Join Date
    09-21-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011
    Posts
    13

    Re: How Do Extract All Images From A Excel Spreadsheet All At Once Into A Folder?

    ***BUMP*** Still need help

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,114

    Re: How Do Extract All Images From A Excel Spreadsheet All At Once Into A Folder?

    Save Picture must be a feature of Mac version as it is not available in Excel on PC.

    Have tou tried saving the workbook as HTML? This should store all images in a sub folder.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    09-21-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011
    Posts
    13

    Re: How Do Extract All Images From A Excel Spreadsheet All At Once Into A Folder?

    I can save it as a HTML but i can't seem to save them into a folder then. Anyone else able to Please help me?

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,114

    Re: How Do Extract All Images From A Excel Spreadsheet All At Once Into A Folder?

    when you open the html output in a browser do you see the images?

    The subfolder and the exported images should automatically be created.

  7. #7
    Registered User
    Join Date
    09-21-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011
    Posts
    13

    Re: How Do Extract All Images From A Excel Spreadsheet All At Once Into A Folder?

    Yes, I see the images but the there is also the text too, when I highlight them all it won't allow me to save it. How do I see the subfolder or create a subfolder? Ive never created a subfolder before....

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,114

    Re: How Do Extract All Images From A Excel Spreadsheet All At Once Into A Folder?

    So if the html renders correctly that would suggest the images are available.

    If the file is called Book1 then in the same folder as you saved the file should be a folder called Book1_Files. In that folder should be the images.

  9. #9
    Registered User
    Join Date
    09-21-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011
    Posts
    13

    Re: How Do Extract All Images From A Excel Spreadsheet All At Once Into A Folder?

    It worked !!!! You are my hero !!!! Thank you!!!!!!!!

  10. #10
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: How Do Extract All Images From A Excel Spreadsheet All At Once Into A Folder?

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Can't extract images from Excel 2007 Document
    By jsteve01 in forum Excel General
    Replies: 10
    Last Post: 05-23-2013, 12:27 AM
  2. Replies: 2
    Last Post: 10-24-2012, 01:39 PM
  3. Importing images & image names from a folder into excel spreadsheet
    By RaquelG in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-13-2012, 06:11 AM
  4. Copy images from a folder & paste them in Excel
    By karan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2011, 02:40 PM
  5. [SOLVED] How do I un-embed images in Excel and save them to another folder.
    By marcusgrimm in forum Excel General
    Replies: 1
    Last Post: 06-23-2005, 07:05 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