topic Re: Changing Font in Macro in QlikView

Changing Font in Macro

Mon, 08 Aug 2011 08:44:51 GMT

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..

Re: Changing Font in Macro

AlexOmetis — Fri, 23 Aug 2013 09:10:21 GMT

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).

Re: Changing Font in Macro

Andrea_Ghirardello — Fri, 23 Aug 2013 11:12:41 GMT

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