inserting image and document files into the spreadsheet

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.

you can insert a picture into a comment
http://www.contextures.com/xlcomments02.html#Picture
--
paul
remove nospam for email addy!



"Cornpone" wrote:

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

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 <none@nobody.no> wrote in message
news:43dc0677$0$29934$c3e8da3@news.astraweb.com...
> 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 wrote:
> 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.

Shailesh Shah wrote:
> 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 <none@nobody.no> wrote in message
> news:43dc0677$0$29934$c3e8da3@news.astraweb.com...
>
>>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.
>
>
>


Hello Shailesh Shah,

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

paul wrote:
> 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.

Shailesh Shah wrote:
> 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.

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


On Sun, 29 Jan 2006 15:25:01 -0800, Cornpone <none@nobody.no> wrote:

>paul wrote:
>> 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.

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)


"Cornpone" <none@nobody.no> wrote in message
news:43ddaf9a$0$27073$c3e8da3@news.astraweb.com...
> Shailesh Shah wrote:
>> 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.