how to chagange formating vb macro code for exporting the objects?

[#1]

iam using vb macro code for exporting the objects

and i want to change  format

is there any possibility formating like color ,font ,header,is

we can implement this  vb script

please help on that

please find qvw file and excel file

excel file contain output format

cover page header  like

i want same  excel out if i import to excel by using macro

[#2]

any body help on that.