Results 1 to 6 of 6

Getting data into Excel worksheet from Word Documents??

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2010
    Location
    Denmark, Europe
    MS-Off Ver
    Excel 2010
    Posts
    62

    Getting data into Excel worksheet from Word Documents??

    Hi

    Can someone help me (again) with a bit of vba coding? In need to write a code that looks into the cells in column C (containing paths for doc files on my computer) opens the *.doc file, finds the first line beginning with u* and copies/selcts whatever it finds of numbers [0-9] and of the characters [-] and [.] ending at the next ^p (paragraph break) What I'm looking for is a ref-number alway following a keyword staring with a u* in one of the first lines of the documents (not always the same line though). The ref-number always takes the form "[0-9]*\-[0-9]*\-[0-9]*\.[0-9]*"

    This selection should then be copied to the cell i column A on the same row.

    No changes should be made to the doc files....

    thanks.
    Last edited by Flabbergaster; 12-05-2012 at 11:49 AM.

Thread Information

Users Browsing this Thread

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

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