Exporting

[TGalin]

I have an Excel workbook and I want to export every worksheet into a word
document? Is this possible and if so can you tell me how I can do it?

 

[Shane Devenshire]

Hi,

Excel workbooks contain 256 columns and 65,536 rows or much more in 2007,
and you want all of that in an word document?

You can copy and paste a range from Excel to Word, just use copy and paste.

You can create a link from Word to Excel using Copy, and in Word choosing
Edit, Paste Special, Paste Link.

You can imbed the entire workbook in a Word document by moving into Word and
choosing Insert, Object, clicking the Create from File tab, and Browsing for
your file.

 

[TGalin]

Your recommendations work great for the first worksheet in the workbook.
Thank you. Is there a quick way that you know of to export the entire
workbook all at once?

 

[Shane Devenshire]

Hi,

The last suggestion is the only solution I am aware of other than writing a
macro.