exporting report from access to excel with proper formatting

[ds_8805]

hello everyone.. I have created reports in access and would need to export it to excel with proper formatting .. like for example the the font for the header shouldbe bold etc.. I have managed to export the files successfully by coding but I am not ableto do it with proper formatting. I am a newbie at this and any help wld be greatly appreciated!
Thanks!

 

[wiklendt]

don't know about exporting REPORTS to excel, but i've done some query exporting to excel with formatting that i want. here's the thread related to that, and perhaps you can alter it to suit exporting report (if it can be done? i didn't think reports/excel were compatible, necessarily - then again, i'm still a newbie too)

http://www.access-programmers.co.uk/forums/showthread.php?t=177181&highlight=freeze

 

[ds_8805]

Thank u very much for ur help. I will try to work on it!