Solved: Output a single record/form as Excel File?

[andysuth]

Hi,

Does anyone know how to output a single Access Record or view of a form as an Excel format file?

I don't want the whole database, I just want one where people can scroll through the records and highlight the record that is appropriate and click a macro button for "Save as Excel"

Pref. Excel 2003 or 97 or compatible.

I get the Highlight current record/"Export/XLS/Selection", but how do I do that automatically?

Thanks.

-Andy