Results 1 to 10 of 10

Command word from excel

Threaded View

  1. #1
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Command word from excel

    I have a text file (*.txt) that I want to modify before using in excel. I want to replace the return carriage with (Char 13) as long as the return carriage is not proceeded by a certain code. The code is fixed but there is a lot of different variations to the code, so if someone could help me with only one variation, I hope I will be able to do the rest.

    So the macro should:

    1. open the txt file via Word
    2. replace the carriage breaks that are not proceeded by a code with (Char 13)
    3. save the txt file

    Example attached.

    Thanks.

    Abousetta
    Attached Files Attached Files
    Last edited by abousetta; 05-04-2010 at 05:17 PM.

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