Discussion in 'Windows Desktop Systems' started by NLM, Apr 12, 2003.
How do I make a marco that transfers an excel file to word.
Moved to Applications
Please only post your question in one forum.
Dim appWD As Word.Application
' Create a new instance of Word & make it visible
Set appWD = CreateObject("Word.Application.8")
appWD.Visible = True
' Copy the data for the new document to the clipboard
' Tell Word to create a new document
' Tell Word to paste the contents of the clipboard into the new document
' Save the new document with a sequential file name
appWD.ActiveDocument.SaveAs Filename:="Full Printout"
' Close this new word document
' Close the Word application