Export Access 97 Report to Excel

[misssaraliz]

I am exporting a report from MS Access 97 into Excel. The same report with different data will be exported daily using a command button that runs a visual basic command to export the report into Excel. The visual basic command also automatically assigns a new name to the report daily using the date function. Then this report will be emailed daily to several users. I need to find a way to set up a macro that will automatically run when the user opens the report. This macro will apply formatting such as changing page orientation, margins, field size, etc.

Do I run this macro from the command button in the VB?

Also, is there a command in the macro that I can include to tell it to delete columns if there is no data in them?

Thanks for any help you can provide. I will be cross-posting this since I'm not sure of the best place to put this.