Excel VBA How to Copy excel columns into NotePad

[jceast7]

I have 3 column in and excel vba file that I want to copy into NotPad, which I can do but since the text content in the cells of each column vary in length, NotPad does not maintain the format as copied, but the copy results are altered and not in line as desired. Is there a way to ix this??

Thanks

jceast7

 

[jceast7]

Re: Excel VBA How to Coply excel columns into NotePad

This seems very complicated way to process the copy and paste indea into NotePad. Is it possible to get more detail on the steps of your code? Example, what does each step do? Then I can better understand the process and edit to fit my variables??

Thanks

 

[DanteAmor]

Re: Excel VBA How to Coply excel columns into NotePad

What is the ultimate goal of taking it to notepad?