>I've done as far as exporting the table to excel. I know, from your intro, how to rename cells (e.g. to give better column headings) but I need to:
>
>1) remove duplicate cells' text, e.g. I don't want a column of bus operators all the same, but when the op. changes I want the name to show.
>
>2) reorder the columns. The cursor is not in the same L-R field order as the format of my report but I'd like to get the s/s to resemble it as much as poss.
>
>3) provide totals at route, operator and grand levels
>
>4) slot in an extra row, at top, with a heading.

I am really no expert in all of these subjects - but I think that in each and every case, you should save a macro (Note 1), look at the generated code, and adapt it to Visual FoxPro. If you have trouble with the latter step - this is likely to happen in some cases - ask specifically, here on the UT, how to adapt such-and-such a code.

(Note 1)Save a macro, do the desired action (for instance, insert a row), stop saving the macro, look at the generated macro code.