+ Reply to Thread
Results 1 to 8 of 8

Excel 2013 VBA from Excel to Notepad Replace function

  1. #1
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Excel 2013 VBA from Excel to Notepad Replace function

    Good day,

    I already have the code to copy and paste from Excel to Notepad, Seems that the transfer is adding spaces everywhere.

    Is there a "SendKeys" shortcut anyone knows that will do the following:

    After it's been copied as you will see in the code bellow, to remove the empty space by the "Edit/CTRL + H function"

    Find What: " "
    Replace with " "

    Please Login or Register  to view this content.
    This is within notepad after the code is generated:
    Please Login or Register  to view this content.
    I would need it to look like this:
    Please Login or Register  to view this content.
    Any help would be appreciated
    Last edited by Excelnoub; 05-16-2020 at 01:37 PM.
    Click the star icon in the lower left part of the contributor's post and add Reputation if we have helped you .

  2. #2
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Excel 2013 VBA from Excel to Notepad Replace function

    Says the "SendKeys" method is glitchy too, and well yes I am open to alternative methods.

  3. #3
    Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    185

    Re: Excel 2013 VBA from Excel to Notepad Replace function

    hi,

    Why would you want to open notepad?

    just write the txt file in excel itself
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  4. #4
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Excel 2013 VBA from Excel to Notepad Replace function

    Cause I have more code running in the background... Unless there is a simple way?

    I have more data being transferred and when the txt file is generated it's more easier for others to view this report.
    Each line (rows) is individual, and I have 100 rows to transfer each day. So this makes my life and the clients life better.
    There is a random function so the txt will always change but I need it to be clean, and plus not all have word or excel, .txt is the best option for me at the moment.

    I mean I could do it manually each time, as you see the code doesn't save, it only open and paste the value of the Range("A10:N110").

    A10:N10 (on it's own rows)


    A100:N100 (on it's own rows)
    Last edited by Excelnoub; 05-16-2020 at 04:07 PM.

  5. #5
    Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    185

    Re: Excel 2013 VBA from Excel to Notepad Replace function

    creating the txt file from excel is the best way to go


    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Excel 2013 VBA from Excel to Notepad Replace function

    Quote Originally Posted by Joske920 View Post
    creating the txt file from excel is the best way to go
    K Thank you, will try and play with this code

  7. #7
    Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    185

    Re: Excel 2013 VBA from Excel to Notepad Replace function

    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Excel 2013 VBA from Excel to Notepad Replace function

    Oh this works lol wow ok just came back and... Cool awesome thank you so much Joske920 this will help me lots

+ 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. excel 2013 spreadsheet will not search and replace '= with =
    By pvinet in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-22-2017, 05:05 PM
  2. [SOLVED] Cannot Find or Replace caret characters (Excel 2013)
    By nlexcel in forum Excel General
    Replies: 7
    Last Post: 05-13-2016, 10:19 AM
  3. Replace words in notepad with values given from excel
    By balajinatarajan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-03-2016, 03:39 PM
  4. VBA to find and replace from a table in excel 2013
    By Nirmall in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2016, 01:44 PM
  5. Excel 2013 delete and replace a macro
    By Arismac in forum Excel General
    Replies: 2
    Last Post: 02-17-2016, 06:30 AM
  6. Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-07-2015, 04:25 PM
  7. [SOLVED] Excel 2013 - VBA Find and Replace
    By colbyski90 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2014, 09:51 AM

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