report to excel issue

[associates]

Hi,

I was wondering if anyone might be able to help me here. I have a form that has a button called export to excel. I have tried to export report to excel and it works. However, i've been asked to produce an excel file that looks like that in the report in the access.

Because in the report, it looks more fancy. it's got columns, headings and things like that. It looks more professional in the report.

I'm not sure if this is a can-do. Your help is greatly appreciated.

Thank you very much in advance

 

[statsman]

Using the query you used to create the report, create a new report (how about somting original like "RptExcel").
In the RptExcel just place your headings in the detail header section and your actual data in the detail section. You won't need any of the other sections.
Make sure that you check to make sure your data has enough room. Expand or contract the text boxes manually. Make sure the headers are exactly the same size as their text boxes.
When you've got everything right, export the report to Excel.
You should have a spreadsheet where everything is perfect.
Create a second spreadsheet in Excel with all the bells and whistles (grahics or whatever) and save that. Copy it an paste it onto the top of the spreadsheet you just created from Access. Voila, the spreadsheet of your dreams.

If there's a way to automate this procedure, I would apreciate anyone telling me.