hi expert..
i have excel file that contains multiple sheets. In every sheet in cell B6,C6,E6 always contains 3 picture with different type extension e.g. (.jpg, .jpeg, .png).
i want to extract or export all images from multiple sheet into a folder name like "OK" with the new file name picture sequences number series, like photo1,photo2,photo3, etc...
would you help me out with your vba or macro code to solve this problem..
this my file attachment..
any help greatly appreciated...
john m
Rename the file extension to .zip
Extract the zip file
Browse to \xl\media, you will see all pictures in the excel file
❖ Please mark your thread is SOLVED if there has been offered a solution that works fine for you.
❖ If you like solutions provided by anyone, feel free to add reputation by clicking on ✶ Add Reputation bottom left of their posts.
thank but no fully work..i mean not all image can be extracted from every sheet
where is the problem?
The pictures at C6 in every sheet are the same, so is C7. They are duplicate from only one picture.
Once inserted into Excel, they are all the same format. They do not retain the extension information.In every sheet in cell B6,C6,E6 always contains 3 picture with different type extension e.g. (.jpg, .jpeg, .png).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
hi..huuthang_bd & Ali...thank for your helping but for reason i want the duplicate pict can be exported too..maybe using vba or macro
Below code will generate a folder at the file's location, named by [filename]_Pictures with sub folders are named by sheet name inside, inside each subfolder is all pictures on the sheet.
Please Login or Register to view this content.
yes...really you're great!!! thank again for your kindness
Last edited by AliGW; 07-01-2020 at 06:31 AM. Reason: Please don't quote unnecessarily!
hi..huuthang_bd
sorry maybe i missing it about my request..
after run your code the picture always create duplicate..
i just want picture exported as is as look into every each sheet
would you help me out ...thanks
Last edited by Jhon Mustofa; 07-01-2020 at 07:12 AM.
Please re-read post #5: all three images on each sheet, once imported into Excel, are exactly the same.i just want picture exported as is.
Sorry, I don't understand. What mean is "exported as is as look into every each sheet"?
Jhon said this:
He has not understood that the three images, once imported into Excel, no longer have these extensions and are now all in the same format.In every sheet in cell B6,C6,E6 always contains 3 picture with different type extension e.g. (.jpg, .jpeg, .png).
hi hi..huuthang_bd
like in my sample above i have 5 sheets. for every one sheet contains 3 picture so total pictures in 5 sheets = 15.
after run your macro code, total picture success exported = 30 that overload should be keep 15.
here this picture AFTER RUN MACROAttachment 684916
here this SHOULD BE THAT I WANT Attachment 684917
I can't see your pictures. However, before I posted the macro, I have tested it. When i ran the macro, it generated a folder with 5 sub folders inside and each sub folder had 3 pictures inside.
Last edited by AliGW; 07-02-2020 at 12:04 AM. Reason: Please don’t quote unnecessarily!
hi..
i have try again with new file the result is not correct...
total picture after success exported = 2 SHOULD BE ONLY 1...why picture has exported to be duplicate?
please, check my new attachment file to make sure it wrong..
Last edited by Jhon Mustofa; 07-02-2020 at 10:36 AM.
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
hi aligw...thank you but this my original post not from other sites (a cross post)
the really true my post
Jhon - you may wish to rethink that response. If you do not provide the cross-post link (I know where the cross-post is), then you will be banned from posting here again for ten days and this thread will be locked.
To be clear - it does not matter in which order the threads were created.
Last call for that cross-post link, Jhon.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks