Pictures

  • Thread starter Thread starter Peter Damon
  • Start date Start date
P

Peter Damon

How d I insert a picture into a cell? I want to create a DB wi pictures &
txt and insert them into a document with Publisher. Is there a way?

I envision each table row including two columns of pictures and three
columns of text.

Thanks!
 
First, pictures can't be inserted into cells - they live on the drawing
layer above (or below for watermarks) the cell layer, so aligning
pictures with cells takes some overhead, either manually or via
automation.

Also, while XL can do just about anything, if this is for an extensive
project, I would think that there are lots of more appropriate
solutions, including both general and photo-oriented databases (though I
wouldn't use Access with pics).

Do you need to do extensive calculations along with the pics? That's the
only time I'd do a db like this in XL.
 
Inserting a Picture onto a worksheet and Lock to a Cell:

EDC Excel & VBA Tips: Insert pictures -- Ole P. Erlandsen
http://www.erlandsendata.no/english/vba/ws/insertpictures.htm
inserts a picture and resizes it to fit the TargetCells range
Though this is or at least looks like what you asked for I
doubt that it would be transferred to MS PublisherP

Insert a Picture into a Cell Comment:

Debra Dalgleish has instructions for putting the picture into a
cell comment. "Add a Picture to a Comment"
http://www.contextures.com/xlcomments02.html#Picture
since it is a cell comment it might not work well in converting
to MS Publisher.

Use Mail Merge to create a catalog:
[ http://www.mvps.org/dmcritchie/excel/xl2gif.htm#related ]

Merge Pictures and Words - Oh My!, by Cindy Meister,
creates a catalog from text wording and external pictures
from an Excel database using Mail Merge in MS Word.
Computer Companion, E-zine article
http://www.computorcompanion.com/LMMArticle.asp?ID=126
Debra Dalgleish (short posting), similar, less explanation.
http://www.progency.com/other.html#screenrip32

Create HTML with pictures with help from Excel:

I'm not familiar with MS Publisher but I can use Excel
spreadsheet to create HTML. i.e.
="<a href=""" & D1 & """ title=""" & D1 & """><img src=""../200/" & D1 & """ height=""150"">"

so of course with more of the same you could include
generating an entire table row for HTML from Excel.


Are you creating a catalog? Where is your permanent
repository when finished (the place where you would
update). Not that I can help you further
but you indicate you want to create a data base.

Please post back to let us know what you ended up doing.
---

The Site mentioned by Luc is in Dutch here is a
TransSoft.com translation of item #24 in
http://users.skynet.be/onderland/Excel.htm#Lessen24-InsertPicture

Images pick up and adapt to file altitude. This file shows how you can
pick up images which in the same map sit as this resistant
automatically. You MUST this resistant AND the images store firstly in
the same map. Also you can pick up images by means of a formula.
[hmm, perhaps not the best translation, I expect map is directory ]
SysTran would not convert the entire page so translated a portion.
 
Normally one uses either an MS Word table or an Excel spreadsheet as the DB
for an MS Publisher mail merge (catalog merge) operation. I tried this with
an MS Word table (which easily accepts pictures), but you're right -
Publisher won't transfer it.

Does anyone have any other ideas? Thanks for the response!
 
Back
Top