+ Reply to Thread
Results 1 to 3 of 3

Code to identify date in word file

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    17

    Code to identify date in word file

    Hi,

    I am looking for a code that will search for previous weeks date from current date in a word file and copy the data below that date.

    Example: Word File

    (14th January– 18th January)
    Redemption
    • Morgan Stanley .

    (12th February – 19th February)
    Redemption
    • Landgrove Synthetic

    (4th – 8th March)

    Unwound
    • Greylock Synthetic

    (23rd-30th april)

    Accelerated Repurchase

    • Tiers Funding Trust Certificates

    ...............

    So if today is 2nd May, the macro should look for previous weeks date (i.e (23rd-30th april)) and copy the data below that.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Code to identify date in word file

    There are some really talented problem solvers on this forum, but you might have better luck in a Microsoft Word forum.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Registered User
    Join Date
    06-25-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Code to identify date in word file

    Ok Can we create something like I give the path to the word file. It then copy's the word data to excel and then do what is mentioned above?

+ 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. Pasting excel table one after another in Ms-Word file Using VBA code
    By manish_ti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2012, 02:06 PM
  2. Word Mail Merge and Name File (VBA Code Error)
    By wealthistime in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-14-2011, 03:47 AM
  3. Find and replace the date format in Word file
    By vinwin06 in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2010, 09:11 PM
  4. Identify word from a cell
    By kamalthakur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2008, 05:54 AM
  5. [SOLVED] identify a word in a string then change the format of that word
    By EazyExcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2005, 03:06 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