excel to word?

[nancyo]

I am just learning about excel and macros. Is it possible to write a macro from an excel spreadsheet to copy the spreadsheet into a word document? This would need to be from a specific file (in a certain directory) to a specific word doc (in a specific directory).

The trick is that the excel file would be used over and over with different information each time, and this information would need to go to the corresponding new word doc each time.???

 

[nancyo]

I have searched many web sites, and have found example codes on how to write a macro for copying a spreadhseet from excel to word. Unfortunately, I am so new to VBA that I don't really understand the codes. I have tried modifying the one below, and I still can't get this to work. Anyone have any suggestions?