VBA code to pasting to Notepad, without tabs

[blondeambition]

Hi,
I need help with figuring out vba code to paste data from Excel to Notepad, without the spaces in between each word/number. I would like to replace the space with these, "|".

Any ideas?
Thanks.

 

[Andrew Poulsom]

Here's an example:

http://www.mrexcel.com/forum/excel-questions/213591-pipe-delimited-files.html

 

[blondeambition]

I couldnt get that to run.

 

[Andrew Poulsom]

What do you mean by "I couldnt get that to run" exactly?

 

[blondeambition]

The code you gave me didn't work.

 

[blondeambition]

I got "path not found" for this line: Open FileName For Output As #FileNo

 

[Andrew Poulsom]

The first line of the procedure does say "Change file name to suit", so did you do it?

 

[blondeambition]

I thought I did, but I guess what I did was wrong. What would I change the file name to? Don't tell me its the word "suit"...

 

[Andrew Poulsom]

The name of the file doesn't matter but the path must exist and you must have rights to it.

 

[blondeambition]

Can I just paste the data to any notepad instead of a specific file? I would rather do that.