+ Reply to Thread
Results 1 to 2 of 2

Problems exporting a table - find/replace data inside a table in word through excel vba

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    Venezuela
    MS-Off Ver
    Excel 2010
    Posts
    9

    Problems exporting a table - find/replace data inside a table in word through excel vba

    Hello y'all!

    I'm smacking my head down with something I'm pretty sure that's simple, but I couldn't find any proper solution for it

    I made a code that succesfully paste an excel table to word, this table has four strings with differents text formats an each cell, after pasting I'd like to find the first of four strings ("FOTO") and replace it with a picture stored in the sheet1 of my excel workbook.

    The problems are:
    1. The pasting starts fine until page 2 where only pastes the table with content skipping the format.
    2. I can't find the way to find, using the find method, the "FOTO" string so after selecting it, it'll be overwritten with the Picture mentioned before. I don't know if this is happening because they all it's inside a table.

    Here is a piece of the code, give a look please:

    Please Login or Register  to view this content.
    I hope someone can help me

    Thanks is advance

  2. #2
    Registered User
    Join Date
    04-24-2012
    Location
    Venezuela
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Problems exporting a table - find/replace data inside a table in word through excel vb

    Hello!

    I still have both unsolved situations but I've bypassed the pasting issue making each pasted section on a different word document... A very undesired solution but worked.

    Now, I've to replaced the word "foto" inside of each cell of a 2x2 table within the word document while it's being created, with an image stored on sheet1 of excel's document.

    I've tried some methods found out there but it seems that they don't apply to captions inside a table.

    Thanks in advance

    Antonio

+ 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. [SOLVED] Find & replace text in a table nested within a header for a batch of word files
    By Tino XXL in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2014, 08:38 AM
  2. Exporting excel table to *currently open* word doc
    By aserle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2013, 11:57 PM
  3. Creating selection inside word table from excel vba
    By Alexander_Golinsky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2012, 01:34 AM
  4. Inside a table use a check box to replace yes no
    By rbpd5015 in forum Excel General
    Replies: 0
    Last Post: 12-07-2010, 11:00 AM
  5. Importing Table from word to excel giving problems
    By wali in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2010, 05:46 AM
  6. Macro exporting data from a spreadsheet to word and retaining it as a table
    By ggabs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2009, 05:53 AM

Tags for this Thread

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