Use €śPAST LINK€ť in Word.
With Excel and Word running and your documents/sheets open in each program.
Set up the Excel sheet CELLS how you want them to look, colors, lines, ect,
then select all cells to be copied to Word and click copy, switch to your
Word document. Then in Word document, at the spot you want to insert the
cells, click PAST - SPECIAL. In the past special window select €śMicrosoft
Excel Worksheet Object€ť and click on the €śPast as Link€ť button. All your
formatting will be copied into Word.
Further any changes you make in the Excel sheet will be reflected in the
word document as well as long as they are both opened. If you make changes to
the Excel file when Word in not open, then later open only the Word file you
will be ask if you want to update the chances that were made to the Excel
file.
Also if you want to move or resize the cells in WORD, Right click on the
cell area and click on format object, you can change how it interacts with
your text, position and so on. Give it a try and let me know how it works for
you.
In terms of the
VB project are you looking for a code to do this?
Good Luck
Dan
Please rate this response, thank you!
"Lizardo" wrote:
I probably should have indicated that I am doing this programatically -
within a Visual Basic program. I'm doing a Range.InsertFile and it's
changing the appearance. Since I am doing about 500 of these, I can't
do a Cut and Paste.
Gary''s Student wrote:
The best way to get a formatted Excel range into a Word doc and preserve all
the details of formattting is to:
1. Select the range in Excel to be copied
2. While holding down the SHFT key, pull-down:
Edit Copy Picture
3. In Word paste normally.
You will have a picture in the Word doc. It will accurately represent the
Excel Range formatting. Also since its a picture, I can be re-sized or moved
like any other picture in a Word doc.
--
Gary's Student
"Lizardo" wrote:
I'm trying to insert ranges from a spreadsheet that has very distinct
row sizes and colors - but the part that is appearing in my Word
document is very different. It has NO color, and it is changing the row
and column sizes.
How do I block this behavior? The sizes I have in the spreadsheet fit
exactly in the area I need to paste it in.