Insert spreadsheet - without changing appearance?

[Lizardo]

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.

 

[Lizardo]

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.

 

[Lizardo]

I do this from a VB program - so technically, the programs are not
"open", nor is it practical to involve anything that requires any user
content. I'm trying to create a few hundred documents via a program, so
cut and paste is not going to work. If I have to resize anything, it
has to be done in code - there's not going to be any user interaction
with these documents. I am going to run a program and they will all be
created.

So far, the ranges are pasted in gray-scale, and this is odd to me. I
can't figure out why it is doing that. Further, it is adjusting all of
my cell sizes and the resulting reports have all of their data pushed
and adjusted - it doesn't look right. I need to see if there's a way to
secure the appearance of the range or what setting I am overlooking.