Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2007
    Location
    Massachusetts, USA
    Posts
    272
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Text / Excel Macro for Find and Replace (MS Word 2003 SP2)

    Hello,

    In the past I used a Excel macro which pointed to a folder full of graphics and changed the name of every graphic, based on rows D5 and E5, D6 and E6 and so forth.

    Now, I am looking for a new Excel macro that will:

    1. Point to a folder full of text files (.MIF files in this case).
    2. Open up each MIF file.
    3. Look for the original file name path from D5 of the spreadsheet, which is: <c>T00010.emf'>
    4. Replace the original file name path with a new file name path, based on row E5 of the spreadsheet, which is: <c>t0101_00_001.emf>

    I have used MS Word Find and Replace macros, but this is different as I need to do a find and replace from a spreadsheet into individual text files.

    Any assistance that can be provided is very much appreciated.

    Thanks,

    -J

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Text / Excel Macro for Find and Replace (MS Word 2003 SP2)

    You write "I am looking for a new Excel macro" but you have posted this in the Word forum. Which is correct? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  3. #3
    3 Star Lounger
    Join Date
    Jan 2007
    Location
    Massachusetts, USA
    Posts
    272
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Text / Excel Macro for Find and Replace (MS Word 2003 SP2)

    Hello Hans,

    I guess I should have posted it to the Excel forum - my apologies. Should I repost it there or can you move the post to the Excel forum - from your end?
    This post deals with the manipulation of a TEXT file through a spreadsheet - so the post was placed here in the MS Word forum.

    Thanks,

    Jim

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Text / Excel Macro for Find and Replace (MS Word 2003 SP2)

    Could you post a link to the thread with the older macro? Thank you.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2007
    Location
    Massachusetts, USA
    Posts
    272
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Text / Excel Macro for Find and Replace (MS Word 2003 SP2)

    (Edited by HansV to provide link to post; I only had to place [ ] around the reference - see <!help=19>Help 19<!/help>)

    Hello Hans,

    It looks like there already is a macro (see <post:=727,094>post 727,094</post:>) that takes care of the request.
    So, I am all set now.

    Thanks for your assistance.

    Regards,

    Jim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •