Convert Excel workbook into Word document?

  Muckle 20:15 10 Aug 04
Locked

A colleague has created a multi (15+) sheet workbook template in Excel that she wishes to enter information into on a weekly basis and convert to a Word document/report each month. Is there an easier way to transfer it to Word than copy and paste each sheet every time?
I am not sure why it has to be in Word format, but she insists!!

  VoG II 20:34 10 Aug 04

It can be done but not easily. A macro is required.

click here for an example - this would need an "outer loop" added to loop through all the sheets. And not much guarantee what the finished article will look like.

I would query why it *has* to be in Word. If it is just going to be printed off, you can format Excel sheets so they print out as if they did not come from Excel.

  Muckle 21:09 10 Aug 04

Thanks VoG - the macro solution is way beyond me and I think your right about 'has' to be done in Word.
I will have to give lessons in page formatting and printing etc...

  palinka 22:12 10 Aug 04

If it's because some people can't open her Excel docs 'cos they haven't got Excel on their computers, there's a simple solution - download "Excel Viewer" from Microsoft's website; it works beautifully.

  THE TERMINATOR 00:31 11 Aug 04

Your friend needs to set up an OLE Object Link and Embedding click here and goto section V....TT

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5