+ Reply to Thread
Results 1 to 4 of 4

Transfer Picture within Userform to Word Document

  1. #1
    Forum Contributor
    Join Date
    08-07-2014
    Location
    London
    MS-Off Ver
    10
    Posts
    148

    Transfer Picture within Userform to Word Document

    Hi all

    I was wondering if someone could help me with this. I am using the below code to transfer information from within a Userform to a word document. The problem is that I can't seem to get the picture to transfer (Pic1), the wording transfers fine.

    Can anyone help with this? Am I able to modify the code or use some sort of .copy method that will work.

    Any help would be greatly appreciated.

    Please Login or Register  to view this content.
    Last edited by ShakJames; 07-12-2017 at 04:13 AM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Transfer Picture within Userform to Word Document

    I think the syntax is something like this. You need the full path and file name of the picture.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    08-07-2014
    Location
    London
    MS-Off Ver
    10
    Posts
    148

    Re: Transfer Picture within Userform to Word Document

    Thanks, AlphaFrog

    Can't seem to get this to work, I get object and method error. My code is below. Please note R596 is a textbox which has the name of the image.

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    08-07-2014
    Location
    London
    MS-Off Ver
    10
    Posts
    148

    Re: Transfer Picture within Userform to Word Document

    Hi AlphaFrog...

    I've managed to work it out. It just need Range just before Inline shapes. Thanks for all your help!

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using a Userform on a Word Document
    By Queenofmycastle in forum Word Formatting & General
    Replies: 5
    Last Post: 03-11-2017, 03:37 AM
  2. Using Excel VBa to Insert a Picture and add Caption to Word Document (Office2010)
    By DAB257 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2015, 11:23 AM
  3. [SOLVED] Insert picture next to text in Word 2013 document
    By metsmaniac in forum Word Formatting & General
    Replies: 4
    Last Post: 07-11-2014, 03:09 PM
  4. Transfer data from excel form to word document
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2011, 03:05 AM
  5. Replies: 1
    Last Post: 02-19-2006, 12:10 AM
  6. Replies: 0
    Last Post: 01-19-2006, 01:10 PM
  7. how do I transfer information from excel to an existing word document using a macro
    By sweetiez1114 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2005, 09:06 AM

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