PDA

View Full Version : Macro's for printing



Ruckley
03-30-2011, 03:13 AM
Hi.

Anyone know if there is a way of printing a sheet directly into a word file from Excel?

thanks.

:thumb

mdmackillop
03-30-2011, 05:25 AM
Do you mean Copy and Paste? Can you please clarfy what you are trying to do.

Ruckley
03-30-2011, 08:19 AM
I have a print worksheet function that allows the user to print out some tables. Instead of sending it to a printer (as it currently does), I'd like it to print it into an MS Word file.

GTO
03-30-2011, 08:26 AM
Hi there,

It still sounds as if you mean copy and paste the 'table' into a Word document. Is that correct?

Also - is the table to be inserted as an excel object, or converted to a Word table; and (might as well ask) is this to a new Document or are we opening a Word file?