Convert Excel workbook into Word document?

  Muckle 20:15 10 Aug 2004

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 2004

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 2004

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 2004

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 2004

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.

Elsewhere on IDG sites

OnePlus 6 review

Best art and design exhibitions in 2018

MacBook Pro keyboard issues and other problems

E3 2018 : dates, conférences de presse, billets et plus