Changing Font in Macro

[#1]

I have exported a straight table data to Excel using macro.

I have exoprted the table caption as a header in Excel.

How can I make the caption into bold and change the font also?Please help.

chartCaption1 = Left(tableToExport.GetCaption.Name.v,50)

curSheet.Range("A1") = chartCaption1
   

Thanks in advance..

Soumya..

[AlexOmetis]

I know it's a long time since this question was asked... but I'd recommend looking at NPrinting for your formatted exports to Excel. It allows you to bring over or replace the QlikView formatting in exports. As well as that, it works with Word, PowerPoint & HTML (for emails & web pages).

[Andrea_Ghirardello]

I agree with Alex, take a look at NPrinting.

In any way try this:

     sheet1.range("A1").Font.Bold = true

     sheet1.range("A1").Font.Name = "Tahoma" 

     sheet1.range("A1").Font.Size = 24