Is there a way to insert a word document into a single excel cell

Is there a way to insert a word document into a single cell of an excel
worksheet that would not expand the cell yet give you full veiw of the
document if you scrolled over the cell.
Let's say for example I am creating a schedule on a calender. I want to see
the heading of the word document when I open the excel workbook but want the
calender to remain the same size unless I scroll over the cell that holds the
information I need.

I have used a similar technique (not word documents) by dynamically changing
the cell comments text and size - it might be a way forward?

With Range("A1")
.AddComment
.Comment.Visible = False
.Comment.Text Text:="This is a new comment"
.Comment.Shape.ScaleWidth 2.16, msoFalse, msoScaleFromTopLeft
.Comment.Shape.ScaleHeight 1.74, msoFalse, msoScaleFromTopLeft
End With

I guess there is no reason why a word document could not be opened and
pasted into the comment - not sure about format and size restrictions?

--
Cheers
Nigel



"Marty in Austin" <Marty in [email protected]> wrote in
message news:[email protected]...
> Is there a way to insert a word document into a single cell of an excel
> worksheet that would not expand the cell yet give you full veiw of the
> document if you scrolled over the cell.
> Let's say for example I am creating a schedule on a calender. I want to
see
> the heading of the word document when I open the excel workbook but want
the
> calender to remain the same size unless I scroll over the cell that holds
the
> information I need.

Hello Nigel,

The method you used sounds interesting. Please explain a little further.
First question: Does the comment fill the viewable surface of the cell or
does it appear as a tag? Second question: Does this method allow the user or
viewer to print the contents of the single cell by just clicking the cell and
the print button? Third question: If the answer to the second question is
yes, can you format the comment to appear to be a word document when printed?
Thank you so much Nigel for your time and thoughts.

Marty

"Nigel" wrote:

> I have used a similar technique (not word documents) by dynamically changing
> the cell comments text and size - it might be a way forward?
>
> With Range("A1")
> .AddComment
> .Comment.Visible = False
> .Comment.Text Text:="This is a new comment"
> .Comment.Shape.ScaleWidth 2.16, msoFalse, msoScaleFromTopLeft
> .Comment.Shape.ScaleHeight 1.74, msoFalse, msoScaleFromTopLeft
> End With
>
> I guess there is no reason why a word document could not be opened and
> pasted into the comment - not sure about format and size restrictions?
>
> --
> Cheers
> Nigel
>
>
>
> "Marty in Austin" <Marty in [email protected]> wrote in
> message news:[email protected]...
> > Is there a way to insert a word document into a single cell of an excel
> > worksheet that would not expand the cell yet give you full veiw of the
> > document if you scrolled over the cell.
> > Let's say for example I am creating a schedule on a calender. I want to
> see
> > the heading of the word document when I open the excel workbook but want
> the
> > calender to remain the same size unless I scroll over the cell that holds
> the
> > information I need.
>
>
>