Is it possible to combine/merge images?

[MrFletcher]

Hi,

Since you were all so wonderful with my last problem, I was hoping you could help me again...

What I am trying to do is insert an images into a cells and then merge them together.
To put this into context, I have images of hose fittings and hoses. I would like to have a column of Inlets, a column of Hose Types, and a column of Outlets. I have the images for these three columns and I would like to have a fourth column that is an image of the whole assembly, Inlet-Hose-Outlet that uses the first 3 images merged together. I could do this with Photoshop or something but the shear number of images I need to create would take weeks!

I know you can combine data by using '&' but the images don't work in the same way that regular data does, so maybe I have to insert the images in a special way?

Any help would be very much appreciated.

[Andy Pope]

Do you really mean merge?
Or would the images just be positioned left to right next to one another. If so then yes you could builded a grouped image from single images.

[MrFletcher]

I may not mean merge. But I will need to save and export the images for use in another application.

[MrFletcher]

So, does anybody have any ideas?
I'm not even sure if you can add images the same way that you can add data.

[Andy Pope]

I have already suggested the way to do it.

You need to copy the images, position them and then group them.

If you want to export to another app then you can either use the clipboard by simply copying the newly grouped shape and manually pasting in the other app.
Or save the grouped shape to file using code, as in the PastePicture example on Stephen Bullen's site.
http://www.oaltd.co.uk/Excel/Default.htm

[MrFletcher]

I see, thanks for the suggestion...I tried copying, repositioning and grouping them which works fine, if not for the shear number of times it has to be done.

[Andy Pope]

It should be possible to code the task I described.

[MrFletcher]

Well, that sounds promising! Although I have no idea how to code in excel!

Also, I'm looking into using VLOOKUP to put the 3 component images into cells...am I on the right lines?

[Andy Pope]

vlookup may work if you only have 1 output image to construct.

to make providing code example simpler it would help if you could post an example workbook. Explain how to use it and what is expected in terms of results.

[MrFletcher]

Ok, so this is a simplified version of what I'm trying to do. I think there are around 700 combinations in total so I will need an assembled image for each one.

All of the Inlet, Guard, and Outlet options have their own images and all options need a configured image of their constituent parts.

[Andy Pope]

Please Login or Register  to view this content.

Newly created grouped images are positioned so top left of image aligned to top left of cell in table.

[MrFletcher]

Wow, you are totally awesome! I really can't thank you enough for this.

[arronlee]

Nice sharing, fcimage.

But I have never used the tools you mentioned above.

As for myself, I used to combine/merge images with the help of another image processing SDK.

It is just one of many but I do appreciate its simple way of processing.

Even though I only tried its free trial package to edit images and didnīt check the cost and licensing conditions, it works great for me.

Share with you. And I will try your sharing later.

Thanks again.

[AngieQCC]

Hi Guys,

This is the sort of thing I am looking to do, but I have no experience with VBA etc.

I would like the process to create a new image file based on the combined image.

I have about 2000 products based on 4 or 5 variable options, so want to create an image for the product by combining the pictures of the variables. The variable images are listed as a URL in the excel and then the new image of the combined variables would need to be a URL in Excel.

I know this Thred is 10 years old, but I was hoping someone could help me?

I can send a small sample as an example.

Thanks

[FDibbins]

Hi Guys,

This is the sort of thing I am looking to do, but I have no experience with VBA etc.

I would like the process to create a new image file based on the combined image.

I have about 2000 products based on 4 or 5 variable options, so want to create an image for the product by combining the pictures of the variables. The variable images are listed as a URL in the excel and then the new image of the combined variables would need to be a URL in Excel.

I know this Thred is 10 years old, but I was hoping someone could help me?

I can send a small sample as an example.

Thanks

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread