Huge issues.
I'm new here, so tell me off if I sound like a plebb.

I need somehow a macro that can do the following

publish an access report into word in rich text format
next
save that .rtf as a .txt file
next
open and save that .txt in excel as a .xls

ya.
WTF???

Pleez, any help would be greatly appreciated.......

Hmm, why? Why not just export to .xls?

Read in the VBA help for "OutputTo" or "TransferSpreadsheet". These are available in Macros as well as Modules.

GL with that one... Pushing a report into .rtf will ensure that you wont have any kind of formatting going on, thus your report will look like a jumbled mess.

I've always wondered why MS made a reporting tool that is only useful if you want to print it.

As far as Excel... ya, you can push it to excel, if you are very good at VBA and Excel Macros. Otheriwse you'll be spending many Hours in research and/or spending time formatting the raw data from access, into a nice Excel spreadsheet.

Honestly, MS needs to have a GUI reporting tool that integrates with Excel... TThis would solve many problems and make the world a better place to live in... until then. Coding is the only answer. Blah!

Sorry... I know that wasn't much help...