access macro to excel (heading required please help)

[affan]

Dear all

I have a Macro which will successfully export data from an Access Report to Excel.

I would like to add heading how I can do please help me.
For example I exported data in excel as below mentioned.

I need heading top of the field name
for example i want to write my company name & Report name

 

[Old Man Devin]

You can edit the heading properties of the excel file in your macro.

You can see it being done in the code here.
http://www.dbforums.com/microsoft-access/1661928-access-vba-write-excel-header-footer.html