Linking snaps in a folder to cells

S

starguy

I have snaps in a folder and all snaps are named by serial No. a
1,2,3...and so on. I want that when I put 1 in a cell, snap named as
should appear in right cell (or might be required at left).

could that be done without vba
 
D

David McRitchie

You would need VBA unless you want to do it very manually.
"Insert Selected Picture Into Comment"
http://www.contextures.com/xlcomments03.html#Picture

If you are used to writing your own HTML code, you could create HTML
code using worksheet formulas and insert that code into an HTML page.

If you show a picture in Excel then that picture has to reside in your workbook.

An alternative that might work for you would be use of the HYPERLINK
Worksheet Formula which would alloc you to click on the link and see the
picture.

A1: 001 format as 000
B1: Beautify Sunset
C1: =HYPERLINK("c:\camera-canon20d\img_" & TEXT(A1,"0000") & ".jpg","[pic]")
A2: 002 format as 000
B2: Another sunset from same location
C2: =HYPERLINK("c:\camera-canon20d\img_" & TEXT(A2,"0000") & ".jpg","[pic]")

If you want to create a slide show, you could use a free applicatioin like
IrfanView (irfanview.com) -- I have some directions for my own use on
http://www.mvps.org/dmcritchie/excel/irfanview.txt

Why you should be using newsgroups directly instead of web forums
http://www.mvps.org/dmcritchie/excel/xlnews.htm#postdirect
http://www.mvps.org/dmcritchie/excel/forums.htm
 
S

starguy

if I manually put a picture in a cell, how can I size this with th
change of cell width or length i-e if I change the col width of ro
width that picture should automatically fit in that cell.
I have tried to do this by right clicking on picture and in propertie
selecting move and size with cells but this do not expand the pic as
increase the width of column but when I decrease the width it adjust
its size.
when I increase or decrease row size it adjusts the pic size. onl
problem is that when I increase col width it does not expand the pi
size.

consisely I want that when I put a pic in a cell it shoul
automatically resize when col or row width or length is changed and i
should copy the pic when I copy the whole row or col where pic reside
and paste it in other row or col where required.

hope for quick reply
 
D

David McRitchie

You want to lock your picture to the cells, by aligning all
four edges with cell boundaries.

Right click on the outside of the picture, to bring up Format
In the picture's format choose the Properties (tab),
then pick Move and resize with cells.
I expect you just didn't hit [OK], see if it still has resize
like you say you entered.
 
S

starguy

I have done this rightly. only the thing is that it does not expand when
I increase col size. all other things are okay (i-e decrease in col size
and increase and decrease in row size effect picture size)
 
D

David McRitchie

Works for me in Excel 2002, and the picture that I tested with would have
horizontal and vertical sides and is adjusted to exactly bump into and
lock on each of the four sides to a a cell boundary. Strictly all manually,
no macros. No merged cells, sheet is not protected

My test picture was created from a copy of a small range of cells with
distinctive pattern and font color and
then created using Shift+(Edit, Paste Picture),

Format Picture
Size: all checkable items are unchecked
Properties: Move and size with cells

Try it in a new worksheet, post what version of Excel you are using,
I can only test with Excel 2002 (although I keep thinking it is Excel 2000).
 
Top