Referencing Excel Objects in Word  
Author Message
ZaneZZ





PostPosted: Tue Nov 14 20:44:05 CST 2006 Top

MS Word Doc >> Referencing Excel Objects in Word

I have a Word doc that has a Excel Chart object in it.

Can I create a table in Word and reference the data from the chart object to
the table, if so how??

Word123  
 
 
macropod





PostPosted: Tue Nov 14 20:44:05 CST 2006 Top

MS Word Doc >> Referencing Excel Objects in Word Hi awrex,

If you open the Excel object and access the data underlying the chart, you
could copy that and paste it into a table in the body of the Word document.
Alternatively, you could make a copy of the Excel object and delete the
chart from it to expose the underlying data.

Cheers

--
macropod
[MVP - Microsoft Word]




> I have a Word doc that has a Excel Chart object in it.
>
> Can I create a table in Word and reference the data from the chart object
to
> the table, if so how??


 
 
awrex





PostPosted: Wed Nov 15 10:15:02 CST 2006 Top

MS Word Doc >> Referencing Excel Objects in Word Thank you for your response.

Though I was hoping that I could update the data in the object and have the
data in the table updated automaticaly. I haven't tried using a macro to do
this portion however, would this be a "shortcut"?




> Hi awrex,
>
> If you open the Excel object and access the data underlying the chart, you
> could copy that and paste it into a table in the body of the Word document.
> Alternatively, you could make a copy of the Excel object and delete the
> chart from it to expose the underlying data.
>
> Cheers
>
> --
> macropod
> [MVP - Microsoft Word]
>
>


> > I have a Word doc that has a Excel Chart object in it.
> >
> > Can I create a table in Word and reference the data from the chart object
> to
> > the table, if so how??
>
>
>
 
 
macropod





PostPosted: Wed Nov 15 19:55:44 CST 2006 Top

MS Word Doc >> Referencing Excel Objects in Word Hi awrex,

You could link the two (via Edit|Paste Special & 'Link') but, whether you
use a data table or an embedded Excel table, the updating won't be
automatic - you'd have to open the embedded object and/or print the file
with the 'update links' option checked uner Tools|Options|Print.

Cheers

--
macropod
[MVP - Microsoft Word]




> Thank you for your response.
>
> Though I was hoping that I could update the data in the object and have
the
> data in the table updated automaticaly. I haven't tried using a macro to
do
> this portion however, would this be a "shortcut"?
>
>

>
> > Hi awrex,
> >
> > If you open the Excel object and access the data underlying the chart,
you
> > could copy that and paste it into a table in the body of the Word
document.
> > Alternatively, you could make a copy of the Excel object and delete the
> > chart from it to expose the underlying data.
> >
> > Cheers
> >
> > --
> > macropod
> > [MVP - Microsoft Word]
> >
> >


> > > I have a Word doc that has a Excel Chart object in it.
> > >
> > > Can I create a table in Word and reference the data from the chart
object
> > to
> > > the table, if so how??
> >
> >
> >


 
 
awrex





PostPosted: Thu Nov 16 10:25:01 CST 2006 Top

MS Word Doc >> Referencing Excel Objects in Word Thanks for your help it is very much appreciated... looks like I'll need to
keep this portion manual.

I did have another question... can you tell me why when I create a macro in
Word and attempt to copy and paste from text boxes to text boxes, no code is
generated that references this action or the text boxes themselves?



> Hi awrex,
>
> You could link the two (via Edit|Paste Special & 'Link') but, whether you
> use a data table or an embedded Excel table, the updating won't be
> automatic - you'd have to open the embedded object and/or print the file
> with the 'update links' option checked uner Tools|Options|Print.
>
> Cheers
>
> --
> macropod
> [MVP - Microsoft Word]
>
>


> > Thank you for your response.
> >
> > Though I was hoping that I could update the data in the object and have
> the
> > data in the table updated automaticaly. I haven't tried using a macro to
> do
> > this portion however, would this be a "shortcut"?
> >
> >

> >
> > > Hi awrex,
> > >
> > > If you open the Excel object and access the data underlying the chart,
> you
> > > could copy that and paste it into a table in the body of the Word
> document.
> > > Alternatively, you could make a copy of the Excel object and delete the
> > > chart from it to expose the underlying data.
> > >
> > > Cheers
> > >
> > > --
> > > macropod
> > > [MVP - Microsoft Word]
> > >
> > >


> > > > I have a Word doc that has a Excel Chart object in it.
> > > >
> > > > Can I create a table in Word and reference the data from the chart
> object
> > > to
> > > > the table, if so how??
> > >
> > >
> > >
>
>
>
 
 
macropod





PostPosted: Thu Nov 16 16:48:44 CST 2006 Top

MS Word Doc >> Referencing Excel Objects in Word Hi awrex,

Probably due to a limitation of the macro recorder.

Also, whilst the macro recorder generally returns a macro to suit the
particular actions you've performed, the code thus generated is neither
flexible nor efficient. You usually have to do a lot more work to turn the
code into something that is both flexible and efficient.

Cheers

--
macropod
[MVP - Microsoft Word]




> Thanks for your help it is very much appreciated... looks like I'll need
to
> keep this portion manual.
>
> I did have another question... can you tell me why when I create a macro
in
> Word and attempt to copy and paste from text boxes to text boxes, no code
is
> generated that references this action or the text boxes themselves?
>

>
> > Hi awrex,
> >
> > You could link the two (via Edit|Paste Special & 'Link') but, whether
you
> > use a data table or an embedded Excel table, the updating won't be
> > automatic - you'd have to open the embedded object and/or print the file
> > with the 'update links' option checked uner Tools|Options|Print.
> >
> > Cheers
> >
> > --
> > macropod
> > [MVP - Microsoft Word]
> >
> >


> > > Thank you for your response.
> > >
> > > Though I was hoping that I could update the data in the object and
have
> > the
> > > data in the table updated automaticaly. I haven't tried using a macro
to
> > do
> > > this portion however, would this be a "shortcut"?
> > >
> > >

> > >
> > > > Hi awrex,
> > > >
> > > > If you open the Excel object and access the data underlying the
chart,
> > you
> > > > could copy that and paste it into a table in the body of the Word
> > document.
> > > > Alternatively, you could make a copy of the Excel object and delete
the
> > > > chart from it to expose the underlying data.
> > > >
> > > > Cheers
> > > >
> > > > --
> > > > macropod
> > > > [MVP - Microsoft Word]
> > > >
> > > >


> > > > > I have a Word doc that has a Excel Chart object in it.
> > > > >
> > > > > Can I create a table in Word and reference the data from the chart
> > object
> > > > to
> > > > > the table, if so how??
> > > >
> > > >
> > > >
> >
> >
> >