word.application

Hi All, I have a number of ranges which I would like to paste into word doc, when i do one it works fine however on the 2nd range it doesnt seem to work. So ideally it would paste the first range, then do a few spaces then the second range and so on. Would be good to have the page in landscape...

I have the following code where I am selecting a range from excel, opening a word document, then pasting it to that word document. However, the code does not copy and paste the data, and I am not sure why. Please let me know your thoughts. Thanks!! Sub Report() Dim wdApp As...

Hello, I am working on a project to copy/paste a single cell from various unique excel sheets to their correlating files. This is what I have so far: Sub CopyandPaste() Dim myfile Range("j2").Select Selection.Copy myfile = Application.GetOpenFilename(, , "Browse for Document") Dim wdapp As...

Here's my code to copy a table into Word Sub CopyTable() Dim wdappWord As Word.Application Dim docWord As Word.Document Dim strFilename As String Set wdappWord = GetObject(, "Word.Application") 'Set docWord = wdappWord.Documents.Add strFilename = "C:\Excel\Excel Test.docx" wdappWord.Visible...

I'm trying to copy a bunch of tabs to word. I can get it to create new word documents over an over but I need it to populate the tables in one word document. Here's my code: Sub CopyTable() Dim wdappWord As Word.Application Dim docWord As Word.Document Set wdappWord =...

Hello! I'm attempting to copy a range from Excel and paste into a blank word document. The following code works up to the point where the pasting should occur. If I run the macro a new word documents open but it remains blank. The data is copied and makes it to the clipboard but won't paste...