Inserting Mass amount of pics corosponding with cells in excel

[Guest]

hi
i have a spread sheet that has a coloum with product numbers in it that
corospond with pictures in a folder i have. i was wondering whether there was
a way that i can insert these pics into the spreadsheet in one go without
having to insert 2000 pics indiviually? but i dont want the pics to go in the
same cell as the product number, i want them to go in a sperate cell, but
just on the same row.
can this be done?

 

[Guest]

I assume your cells are rather large, even at thumbnail size. Do you mean a
link to the picture?

God Bless

Frank Pytel

 

[Guest]

ill tell you what i have. I have a whole heap of numbers in coloum (D) that
corospond with pictures in a folder. but i want the pics to go into coloum
(B) but on the same row. its like a catolouge. it will have the picture and
then the info and part number (the numbers which corospond with the
pictures). So yeah, can you help?

 

[Guest]

Mike;

I understand how to create workarounds for what you are wanting to do, but I
don't think Excel has a standard way of accomplishing this. You could:

Create a link to the file on your server/pc/laptop. Click the picture and
the file opens.

Using some other software you could create a table and insert a generic
image tag with the appropriate html code and drag this information down
several rows. Concatenate it and place it in an html file. Then open the html
file and copy all / paste. It will automatically paste as web elements into
excel. You would have to create the thumbnail.

Create an Access database. I can't offer to sell the one that I have, cheap,
to you in this post so you would have to contact me outside of this post. You
could export the database to an excel file. I believe that it would do the
pics to, or you could create reports that would show the information. If this
is a web catalog or a print catalog, this may be a fair option. I prefer to
code all my web stuff. I don't like WYSIWYG editing.

You could probably write some VBA that would allow you to set up the
spreadsheet. Hover your mouse over the link of the picture and the picture
appears. I don't do VBA, but I need to start.

Do a mail merge in Word. You still have to manually set the pictures. Post
your question in the Word>Mail Merge forum for more info. There are already a
lot of posts there about this option. Try reading the newsgroup first.

Sorry I couldn't get you just what you want. I think that you will find
something you like.

God Bless

Frank Pytel

http://groups.google.com/group/excel-applications-and-spreadsheet-programming

 

[Guest]

By this date I'm assuming the need has passed. Just a thought, something so
simple that I'm embarassed to have my name associated. Had the same need
once, and the number of pictures, while considerable, I didn't want to spend
the time needed to script the process. (color me slow)

Remember that you can control-click the windows at the bottom and size them
so each is vertical or horizontaly aligned. And then you can just click and
drag from the explorer folder window with the files over to the exact cell
you want it to appear in excel.

Sorry, I know it's a quick and dirty solution. Hope it helps, Erin