Exporting Access Data into Excel spreadsheet

[Kayleigh]

Hi,

I have a complex database system which currently outputs the data in a number of very detailed forms. I would like to have a button on the form to export this to an Excel spreadsheet whilst substituting the complex details with specific codes and apply formatting for certain situations. What function do I use to do this?

Also is it possible to automatically add comments to certain cells?


Thank you
Krayna

 

[Kayleigh]

Thanks for sharing your DB - very generous and I'm sure will come in useful
Can I mention that the data in yours is quite static but I have a lot of interrelated data which changes acc to user input - the following object must pick up this data and utilise immediately. This is where I am having most trouble coding...