I envision each table row including two columns of pictures and three
columns of text.
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.
In article <rAmdc.3982$QQ6....@nwrdny02.gnilink.net>,
EDC Excel & VBA Tips: Insert pictures -- Ole P. Erlandsen
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"
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
Debra Dalgleish (short posting), similar, less explanation.
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
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.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Luc.Heyndrickx" <lucDitVerwijd...@skynet.be> wrote...
> Save the pictures and the file in 1 folder, and try it.
Does anyone have any other ideas? Thanks for the response!
"Peter Damon" <peter...@verizon.net> wrote in message
"Peter" <peter...@verizon.net> wrote in message