Insert object (excel worksheet)

[Guest]

I have data in a worksheet which I wish to insert in a word document. This
is creating an invoice. When I do the insert object, the worksheet comes
over fine, but it shows all the grid lines from the excel worksheet when I
print the word document. These lines do not show if you print the excel
worksheet and I am wondering what I must do to have them disappear in the
Word document. Also is there a way to automatically insert the worksheet
when you open the .dot file, thus eliminating the insert; object
movements???? Thanks

 

[Cindy M.]

Hi =?Utf-8?B?VGVjaG5vIEdyYW5kbWE=?=,

I have data in a worksheet which I wish to insert in a word document. This
is creating an invoice. When I do the insert object, the worksheet comes
over fine, but it shows all the grid lines from the excel worksheet when I
print the word document. These lines do not show if you print the excel
worksheet and I am wondering what I must do to have them disappear in the
Word document.

Double-click the Worksheet object. Go into Tools/Options and find
the option to turn off the gridlines.

Also is there a way to automatically insert the worksheet
when you open the .dot file, thus eliminating the insert; object
movements????

Could be done using a macro. But you'd probably need to modify any
code your record.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17
2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail