copying from excel to word document

**walid66** · 03-31-2007, 10:05 AM

I would like to know if there is a way to copy a range of data from excel sheet to word document and save the word document in this format "todays date.doc"
Any help would be appreciated in advance.

**Leith Ross** · 03-31-2007, 02:55 PM

Hello Walid66,

Here is the code you are looking for. Just be sure you have copied your range data before running the macro. Todays date is formatted as Mar-31-2007.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**walid66** · 03-31-2007, 11:03 PM

Thanks you so much for all your help.

**walid66** · 04-01-2007, 12:03 AM

can I add to the script the orientation of the word doc. for example change the page to horizontal setup?

**Paul** · 04-01-2007, 12:42 AM

Try this to set the orientation to landscape:

Please Login or Register  to view this content.

Note: I also changed the location where TD is set to the current date outside of the With clause. For some reason it didn't like it when I ran it with that in there. As soon as I pulled it out, it ran perfectly. (There's very little chance the date will change between the time you start the macro and the time it finishes, anyway.)