Hi there,
I have a workbook with a object/shape/picture (basically it's a picture floating above the cells) on it and I can identify the picture, copy it, paste etc but I cannot get arround to save it a .jpg or any other extention file to the folder.
Any ideas how to do it?
Lets say the picutre is a sheets(3).shape("poster_img") and how to get this to save in to: "C:\\blablabla\posters\poster_img.jpg" ?
Thanks
See post #11 on this thread
http://www.excelforum.com/showthread...t=#post4407926
You won't need to worry about the last half of the code as it takes the saved picture and then uses it in an email but the first part of the code does what you want. If you want more detail for your specific issue attach your files and I or someone else can look at it.
Happy with my advice? Click on the * reputation button below
Nice one! It does the job!
Code looks more 'packed-up' than I thought it would be but it's what I wanted.
Btw. What I orginally wanted is that:
The picture I have 'floating' over the cells, lets say called: poster_img (shape/picture) to be inserted on to the userform image_control box.
I've spent a 2 days searching how to so I've gave up and now the process going to be: save picture to file > load to image_box from file. Seems to be only the way, althrough stupid since I have picture on the actual workbook, then export out to .jpg file and then import back on to the same workbook... but... Excel just does not gives me (or I and whole internet never found the way) the option to do this quickly.
I've looked on to Steve Bullen's code that is around the web but this seems not to work for me + code is just too heavy for my purposes.
Thanks anyway as the solution provided does the job!
Glad it worked. The original code I gave you was also a workaround to get a file off a workbook into an email but I had to save the file first then reload it back for the email. Sounds like a similar issue to yours!
Search for Stephen Bullen's PastePicture code. It will allow you to copy a picture on a worksheet and load it straight into an image control.
Originally Posted by rorya
Looks like Penguin's already done this
Must have done something wrong then because it does work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks