View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Erin Erin is offline
external usenet poster
 
Posts: 75
Default Inserting Mass amount of pics corosponding with cells in excel

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
"Frank Pytel" wrote:

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 WordMail 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...et-programming

"mikewebster20" wrote:

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?