Converting RTF file into TXT file

[Alogon]

1. I would like to know how I can convert a file with RTF (Rith Text Format)
extension into a file with TXT extension using VBA code. I tried
"FileSystemObject.OpenAsTextFile" method but it did not work very well.

2. Is it possible to convert a file.RTF into file.XLS directly using VBA code?

Thanks In Advance.

 

[Dave Peterson]

MSWord can read .rtf files.

Maybe you could automate MSWord from your Excel macro.

When I have to do this kind of thing (and it's rare), I'll record a macro in
MSWord to get the syntax correct. Then I'll struggle (and google) to convert
that Word Macro to Excel.

 

[Alogon]

It is right, Mr.Dave.

In Excel Programming>Converting RTF... there is a Joel's code that match
what I wanted.

Thank you.