inserting image and document files into the spreadsheet

[Cornpone]

I am creating my first spreadsheet. I've spent numerous hours
figuring out how to do this on intuition alone. It's how I learn
best I think.

Initially, I just wanted to make an organized list of expenses. Then
I thought I'd put this spreadsheet into a folder, along with
descriptive documents
and scanned jpeg files that may attach, or pertain to a particular
expense, or line in the spreadsheet. Then I
found I could insert comments in cells, eliminating the need for the
creation of "docs!" Great! Now, I want to add these other files on the
basis of which line they might pertain to. I am betting this can be
done, but am wanting to get the shortcut to how, through you.

Can it be done? Please tell me how.

Since I've figured the size of this spreadsheet will be between 3-5
megabytes, it will be too large to distribute by floppy. I believe I
could email deliver it, but don't really want to clog the mail box of
a dialup user. I'm betting it could be uploaded to my site for
viewing, but don't know if I want to go that route either. I'm
getting sort of sleepy, and need to get this done.

Thank you.

 

[paul]

you can insert a picture into a comment
http://www.contextures.com/xlcomments02.html#Picture

 

[Shailesh Shah]

Hi Cornpone,

You can download one com-addins "Image to comment" for excel-2000+ from
below site.

http://in.geocities.com/shahshaileshs/

To reduce file size try another com-add-ins "File Sizer" from this site.

BTW from Picture Toolbar, you can also compress picture to reduced further
reduction in file size.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

 

[Cornpone]

you can insert a picture into a comment
http://www.contextures.com/xlcomments02.html#Picture

Hello Paul,

Thank you for this info. I've successfully added a picture to the
cell. However, I need to learn how to hide the picture and open the
picture. Not just a viewing a thumbnail, but view the added picture
file in it's full size, hopefully without altering the spreadsheet.
Can this be done?

What affect does compressing the picture have on the original
picture? If in fact the original is contained here.

Thanks again for the help.

 

[Cornpone]

Hi Cornpone,

You can download one com-addins "Image to comment" for excel-2000+ from
below site.

http://in.geocities.com/shahshaileshs/

To reduce file size try another com-add-ins "File Sizer" from this site.

BTW from Picture Toolbar, you can also compress picture to reduced further
reduction in file size.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

Hello Shailesh Shah,

Thank you for your time. I haven't had a chance to look this info
over yet, but I will!

 

[Cornpone]

you can insert a picture into a comment
http://www.contextures.com/xlcomments02.html#Picture

I think I may have figured out at least one way. Not sure it's the
most effective way. Anyway, just open the comment and drag its
handles to any size you want? It does indeed enlarge the scan so
that its readable! So cool.

 

[Cornpone]

Hi Cornpone,

You can download one com-addins "Image to comment" for excel-2000+ from
below site.

http://in.geocities.com/shahshaileshs/

To reduce file size try another com-add-ins "File Sizer" from this site.

BTW from Picture Toolbar, you can also compress picture to reduced further
reduction in file size.

I can't find the picture toolbar! [I am tired I think].

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

<snipped>

OK. I have downloaded and installed your file sizer because my
spreadsheet is too large to email, [7.5MB]. I thought I saw a
"compression" button somewhere in Excel while I was creating this
sheet, but I certainly can't find it now! :-0

I do not see any shortcut or program menu entry after installing your
file sizer! How do I find and use it please?

thank you.

 

[Guest]

A couple of years ago some kind (and very clever) person posted the
following code that allows me to paste a graphic within a cell
comment. It works very, very well. I would like to know if it's
possible to modify the code so it will take the graphic from the
current content of the Windows clipboard instead of looking for a
file?

Thanks!

/Lac/


Sub PIC()

Dim myPictureName As Variant

myPictureName = Application.GetOpenFilename _
(filefilter:="Picture
Files,*.jpg;*.bmp;*.tif;*.gif")


If myPictureName = False Then
Exit Sub 'user hit cancel
End If


With ActiveCell
'delete existing comments
If .Comment Is Nothing Then
'do nothing
Else
.Comment.Delete
End If
.AddComment
With .Comment.Shape
.Fill.Transparency = 0#
.Line.Weight = 0.75
.Line.DashStyle = msoLineSolid
.Line.Style = msoLineSingle
.Line.Transparency = 0#
.Line.Visible = msoTrue
.Line.ForeColor.RGB = RGB(0, 0, 0)
.Line.BackColor.RGB = RGB(255, 255, 255)
.Fill.Visible = msoTrue
.Fill.ForeColor.RGB = RGB(255, 255, 255)
.Fill.BackColor.SchemeColor = 80
.Fill.UserPicture myPictureName
End With
End With

End Sub

 

[Shailesh Shah]

Hi Cornpone,

I can't find the picture toolbar! [I am tired I think].

from menu View>Toobars>Picture

10th button for Compress picture.(but not in excel-97)

I do not see any shortcut or program menu entry after installing your file
sizer! How do I find and use it please?

from Menu Tools>File Sizer



Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

Hi Cornpone,

You can download one com-addins "Image to comment" for excel-2000+ from
below site.

http://in.geocities.com/shahshaileshs/

To reduce file size try another com-add-ins "File Sizer" from this site.

BTW from Picture Toolbar, you can also compress picture to reduced
further
reduction in file size.

I can't find the picture toolbar! [I am tired I think].

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

<snipped>

OK. I have downloaded and installed your file sizer because my
spreadsheet is too large to email, [7.5MB]. I thought I saw a
"compression" button somewhere in Excel while I was creating this sheet,
but I certainly can't find it now! :-0

I do not see any shortcut or program menu entry after installing your file
sizer! How do I find and use it please?

thank you.