Macro for table caption back ground color and remove table borders

[ramachandra_gee]

Hi Friends,

we have an interesting requirement from the user.

they want the out put as excel with caption color and removing boders in the chart while exporting as excel.

please find the attched it is exporting as aexcel with palin caption and table borders are coming .please take this macro as a reference and do need to full help.

[Frank_Hartmann]

see attached

hope this helps

[ramachandra_gee]

Thanks for your reply but it is not matching with my requirement.still i am getting borders and caption color is not coming.

Thanks,

Ram.

[Frank_Hartmann]

check attached file

[ramachandra_gee]

no luck ,still i am getting same output

[Frank_Hartmann]

strange. this is what i get:

[andrey_krylov]

Hi Frank. I think the problem may be with the default sheet name in different languages. I've added 

WorkBook.ActiveSheet.Name = "Sheet1"

[Frank_Hartmann]

thats what i changed in my second attached app based on his screenshot!

[ramachandra_gee]

Hey no luck for me, can you please provide alternate macro for getting expected out put.

Thanks,

Ram.