+ Reply to Thread
Results 1 to 3 of 3

Paste Word into Excel

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,954

    Paste Word into Excel

    I get multiple Word documents that I have to perform Cost Analyses on. I usually insert the Word doc as an object in my workbook, but I'd rather be able to paste it into Excel as a picture, or some other format where I can preserve the actual "Look" of the document. I've seen one thread where pasting as HTML is discussed, but I'm having trouble getting the macro to work for me, and it's geared to larger things (my docs are at most 10 pages long). http://www.vbaexpress.com/forum/showthread.php?t=32675
    I'm hoping someone out there has some nifty code I could use, but so far I'm not finding much. Any help on this would be appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Paste Word into Excel

    Why do you want a macro for this? Do you have lots of these to do? If you want a picture, why don't you just use a screen grabber to take a screen shot and the past it in.

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,954

    Re: Paste Word into Excel

    Mallycat,
    Yes, I have lots of these to do, usually 5-10 per week. I never thought about using my screen-grabber; I just tried that, and it looks like it will work for this. I haven't checked the file-size for a 5-10 page picture, but as long as that's not a problem I think this will work. Thanks for the idea.

+ 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