+ Reply to Thread
Results 1 to 2 of 2

Embed Images in multiple files

  1. #1
    Registered User
    Join Date
    07-08-2011
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Embed Images in multiple files

    I have a folder of 800+ word documents that all contain images stored only as a reference. I need to copy these files to another computer INCLUDING the images, meaning they need to be permanently embedded in the .doc (I am not concerned about file size). I think I can figure out how to loop through all the documents, but I have not been successful in scripting the embedding of the image in VBA. Would greatly appreciate any help, thank you!

    Notes: This is the macro I am currently using, which loops through all the documents fine, but the call to run the AddPhotoBits macro (which was created by the program that generated the reports and is therefore password protected so I can't take a look at it) does not seem to do anything at all.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    07-08-2011
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Embed Images in multiple files

    Update: Posting the changes I have made to see if anyone can help. Both scripts seem to execute fine and loop works, but the images are not being embedded. However if I open a document, run just the embed macro and save it, they are embedded fine. I even tried writing a little macro that did nothing but call the PhotoBits sub to make sure I was passing the parameters in correctly and it also worked fine and the images were embedded, so it would appear that somehow the looping action is causing my issues here. Would greatly appreciate any help!

    Here is the macro to loop through files and call the Sub to embed images.

    Please Login or Register  to view this content.
    Here is the macro to embed images:

    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. Embed data files into workbook
    By bnwbass in forum Excel General
    Replies: 0
    Last Post: 08-30-2012, 08:18 PM
  2. Embed Images in excell from UNC path
    By netsrule2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2008, 11:34 PM
  3. Replies: 1
    Last Post: 01-31-2006, 06:35 AM
  4. Replies: 1
    Last Post: 10-03-2005, 04:05 PM
  5. [SOLVED] How do I un-embed images in Excel and save them to another folder.
    By marcusgrimm in forum Excel General
    Replies: 1
    Last Post: 06-23-2005, 07:05 PM

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