Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Techno Grandma Techno Grandma is offline
external usenet poster
 
Posts: 7
Default Insert object (excel worksheet)

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
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default Insert object (excel worksheet)

Hi ?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 :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word - Link Object from Excel printing problems zifer Microsoft Word Help 0 November 1st 06 06:05 PM
Unable to rotate Excel object pasted into Word brandie Microsoft Word Help 3 November 19th 05 04:38 PM
Word 2003 excel object tries to install Project 2000 JQ Bennett Microsoft Word Help 0 November 17th 05 05:18 PM
Inserting Excel tables into Word Louise Microsoft Word Help 13 November 1st 05 06:56 PM
Insert Excel Worksheets into Word Document Barb Reinhardt Microsoft Word Help 1 December 1st 04 06:30 PM


All times are GMT +1. The time now is 11:48 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"