Auto ‘save as’ Excel from Access 97

HI,

I have many queries in Access ’97 that I would like to export (or save..as) excel spreadsheets – automatically.
I am ‘not afraid’ of coding some VBA scripts, to aid in this task – but could someone help get me started.

I am assuminmg I need to use a bunch of API calls to do this…. eeek !

Thakns
MB