Linking snaps in a folder to cells
 

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

could that be done without vba.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=554457

Linking snaps in a folder to cells
 

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...htm#postdirect
http://www.mvps.org/dmcritchie/excel/forums.htm

---
HTH,
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

"starguy" wrote in message
...

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

could that be done without vba.

Linking snaps in a folder to cells
 

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

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

hope for quick reply.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=554457

Linking snaps in a folder to cells
 

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.
---
HTH,
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

"starguy" wrote in message
...

if I manually put a picture in a cell, how can I size this with the
change of cell width or length i-e if I change the col width of row
width that picture should automatically fit in that cell.
I have tried to do this by right clicking on picture and in properties

Linking snaps in a folder to cells
 

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)


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=554457

Linking snaps in a folder to cells
 

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).
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"starguy" wrote...
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)