Hello,

First post - have looked for simple solution, but strugging with search options on the site - please could someone point me in the direction of a good existing solution - or even solve my problem below. I am an advanced Excel (formula) user, but very new to macros and VBA.

I have an Excel 2010 spreadsheet designed for novice users. I'd like a macro I can give to the users that copies data (say from column A "A:A" in the active sheet), then opens a new Word 2010 document, adjusts the margins of the word document to 'narrow', pastes the data into the word document (straightforward paste is fine as the data has already been converted to text within the spreadsheet), then saves the Word document as a file on their desktop with the file name taken from a different sheet (say 'Data') and cell name (say $B$3) in the Excel doc.

I have found a macro that opens a new document (below), but cannot find how to then perform the copy and paste or adjust margins etc.:

Sub New_Word_Doc_RP()
' add a reference to the Word-library
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim i As Integer
Set wrdApp = CreateObject("Word.Application")
wrdApp.Visible = True
Set wrdDoc = wrdApp.Documents.Add ' create a new document

'wrdApp.Quit ' close the Word application
Set wrdDoc = Nothing
Set wrdApp = Nothing
End Sub

Any help appreciated.

Roger