Insert range in a word document

  • Hi fellows,


    I am work in an aplication in Excel, and I have to crate a report with data from the excel document. I have text in the word document and I have to paste a range in the word document, i'm trying to do that but he create a new document but i have to put in the document that excel program create and paste it after the text that I have in document. Can I do that?


    Kind rewards

  • Re: Insert range in a word document


    Quote from palmoura

    problem is solved, thanks anyway


    Please help others in the Ozgrid spirit and tell how you did it.

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: Insert range in a word document


    Quote from Wigi

    Please help others in the Ozgrid spirit and tell how you did it.


    Sorry, but i didn't post my solution because I didn't checked if my solution was correct. Here it comes:


    I have an automation Object, i put a bookmark in that object and I create a range in that bookmark, then I did this

    Code
    Sheet6.Activate
           Sheet6.Range("A12:N24").Select
           Selection.Copy
           If wordDoc.Bookmarks.Exists("pts") = True Then
             wordDoc.Bookmarks("pts").Range.PasteSpecial
           End if
  • Re: Insert range in a word document


    Thank you Palmoura :)

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!