+ Reply to Thread
Results 1 to 2 of 2

word textboxes to excel cells

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    poland, tychy
    MS-Off Ver
    Excel 2010
    Posts
    1

    word textboxes to excel cells

    i receive tables in word that are not tables, only big number of textboxes. it looks like in the example below:

    ScreenClip.png

    is there any way to code transferring these "tables" to excel, cause i have few hundred pages of this stuff and OCR would take forever.

    i never coded word before, have some experience with excel though.

    if any of you can give at least hope, that this is possible, and some methods that can be used, i'd be extremely thankful

    kfsw

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: word textboxes to excel cells

    Extracting anything out of a plethora of textboxes in a structured fashion requires very specific coding and can be difficult to automate. You would do better to convert the document to PDF (which gets rid of the textboxes) and convert it back to Word again, before attempting to extract the data.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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