Excel 2013 VBA from Excel to Notepad Replace function

[Excelnoub]

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

[Excelnoub]

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

[Joske920]

hi,

Why would you want to open notepad?

just write the txt file in excel itself

[Excelnoub]

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)

[Joske920]

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

Please Login or Register  to view this content.

[Excelnoub]

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

K Thank you, will try and play with this code

[Joske920]

Please Login or Register  to view this content.

[Excelnoub]

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