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?

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"TGalin" wrote:

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?

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" wrote:

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"TGalin" wrote:

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?

Hi,

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"TGalin" wrote:

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" wrote:

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"TGalin" wrote:

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?