+ Reply to Thread
Results 1 to 4 of 4

VBA: How to ignore some text from exporting to text file

  1. #1
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    271

    VBA: How to ignore some text from exporting to text file

    Good day, experts.

    I have a macro which exports text from the Range("B21:D36") to text file.
    I need it to ignore (MM) from exporting keeping only 1L. Sample enclosed. Please advise.
    Thanks.
    Attached Files Attached Files
    Last edited by T.I.; 09-29-2020 at 12:53 PM.

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: VBA: How to ignore some text from exporting to text file

    If all you are trying to omit is (MM) then try:

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    271

    Re: VBA: How to ignore some text from exporting to text file

    Hi, I'm afraid I've uploaded wrong file with an old code. Already replaced with the right one.
    (Also, I've tried to apply your code, but something goes wrong. Please take a look.)

    I think now I've got it. And it works.. Thank you!

    Please Login or Register  to view this content.
    Last edited by T.I.; 09-29-2020 at 01:19 PM.

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: VBA: How to ignore some text from exporting to text file

    Sorry I didn't reply sooner, glad you got it worked out though
    Thanks for the rep, feedback, and marking the thread as solved!

+ 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. Exporting Text file without inverted Commas in Text File after Export.
    By Muzaffar Iqbal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2017, 09:15 AM
  2. Replies: 5
    Last Post: 10-16-2014, 08:53 AM
  3. Replies: 3
    Last Post: 12-12-2012, 04:01 PM
  4. Exporting from excel to text file
    By ivannette1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2011, 12:48 PM
  5. Exporting cells to text file
    By lefpe in forum Excel General
    Replies: 2
    Last Post: 09-18-2006, 06:27 AM
  6. [SOLVED] Exporting excel to text file
    By Exceluser in forum Excel General
    Replies: 1
    Last Post: 06-29-2005, 01:05 AM
  7. Exporting from Excel to a Text file
    By oliverrenton in forum Excel General
    Replies: 1
    Last Post: 02-10-2005, 12:09 AM

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