+ Reply to Thread
Results 1 to 3 of 3

Move/Copy the picture from excel workbook to MS word

  1. #1
    Forum Contributor
    Join Date
    04-13-2012
    Location
    germany
    MS-Off Ver
    Excel 2003
    Posts
    185

    Move/Copy the picture from excel workbook to MS word

    Hello Everybody
    I want to copy or move the picture from Excel Workbook to MS Word using Word or Excel Macro.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Move/Copy the picture from excel workbook to MS word

    Hi
    Can you upload sample data?
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Forum Contributor
    Join Date
    04-13-2012
    Location
    germany
    MS-Off Ver
    Excel 2003
    Posts
    185

    Re: Move/Copy the picture from excel workbook to MS word

    Thanks for your reply, by the code below i have copied the simple picture from excel to word, but its not a good example because it copies the data from the range cell to the word, now i want that i have active Word document name "abc.doc" and in excel worksheet i have 5 excel graphs, it take the graphs from excel and put to the desired location in word.


    [code]
    Sub export_to_word()

    Dim wdApp As Object
    Dim wd As Object

    On Error Resume Next
    Set wdApp = GetObject(, "Word.Application")
    If Err.Number <> 0 Then
    Set wdApp = CreateObject("Word.Application")
    End If
    On Error GoTo 0

    Set wd = wdApp.Documents.Add

    wdApp.Visible = True


    Range("D6:j25").CopyPicture xlScreen, xlPicture
    wd.Range.Paste

    End Sub
    [\code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1