Printing Problem in Word Document Created from Excel VBA

My client has asked me to create a Word document from an Excel worksheet.
The data to be copied consist of text in two non-adjacent columns, with
hidden columns between the two columns. The Excel worksheet is set up to
print in landscape format. When I create a document in Word in landscape
format and then copy the Excel data in, I get a nice-looking Word document in
landscape format. When I go to print, however, the right-side of the output
is cut off at about the same point at which it would be if the page width
were 8.5". I've tried attaching a template in landscape format to the
newly-opened document in Word. I'm specifying Orientation=wdorientlandscape,
pagewidth=application.inchestopoints(11),
pageheight=application.inchestopoints(8.5) and a whole lot of other things in
the activedocument.pagesetup properties. I've tried adding the new document
based on a template. Any ideas?

Have you tried inserting the Excel file as a linked object into the Word
document.
--
Kevin Backmann


"Jim Skrydlak" wrote:

> My client has asked me to create a Word document from an Excel worksheet.
> The data to be copied consist of text in two non-adjacent columns, with
> hidden columns between the two columns. The Excel worksheet is set up to
> print in landscape format. When I create a document in Word in landscape
> format and then copy the Excel data in, I get a nice-looking Word document in
> landscape format. When I go to print, however, the right-side of the output
> is cut off at about the same point at which it would be if the page width
> were 8.5". I've tried attaching a template in landscape format to the
> newly-opened document in Word. I'm specifying Orientation=wdorientlandscape,
> pagewidth=application.inchestopoints(11),
> pageheight=application.inchestopoints(8.5) and a whole lot of other things in
> the activedocument.pagesetup properties. I've tried adding the new document
> based on a template. Any ideas?

No. I haven't. I'll give that a shot. I should also mention that, if I go
into Word and then manually set the page orientation to Landscape, things
work.

"Kevin B" wrote:

> Have you tried inserting the Excel file as a linked object into the Word
> document.
> --
> Kevin Backmann
>
>
> "Jim Skrydlak" wrote:
>
> > My client has asked me to create a Word document from an Excel worksheet.
> > The data to be copied consist of text in two non-adjacent columns, with
> > hidden columns between the two columns. The Excel worksheet is set up to
> > print in landscape format. When I create a document in Word in landscape
> > format and then copy the Excel data in, I get a nice-looking Word document in
> > landscape format. When I go to print, however, the right-side of the output
> > is cut off at about the same point at which it would be if the page width
> > were 8.5". I've tried attaching a template in landscape format to the
> > newly-opened document in Word. I'm specifying Orientation=wdorientlandscape,
> > pagewidth=application.inchestopoints(11),
> > pageheight=application.inchestopoints(8.5) and a whole lot of other things in
> > the activedocument.pagesetup properties. I've tried adding the new document
> > based on a template. Any ideas?