Is there any way I can import an RTF file into Excel using VBA?

[Johnny C]

Hi

Our Admin system dumps 60+ files each night in RTF format. Someone has to go into each one and find, copy and paste assorted totals, and it takes forever, and in October that's going to expand to circa 250 files. The Admin system can only export as RTF.

If I could somehow open the file as a txt file in Excel I could automate it for them.

Is there a way I could do this?

Cheers

 

[slinky]

Have a quick nose at this : http://www.mrexcel.com/forum/excel-questions/47227-code-open-rtf-file-word.html

 

[Johnny C]

Cheers, works a treat.

Some other code I found uses objWord.WholeStory.select, any idea what that does as opposed to selecting the doc?