1 Reply Latest reply: Jan 11, 2013 1:44 PM by Abhijit Bansode RSS

    add wordart in excel form vb script

    Abhijit Bansode

      Hi All,

      I want to add certail Text as a word art to excel file from Qlikview VB script.
      I am able to create excel file in macro but still not able to find API to set wordart of excel file from Qlikview VB script.

      I have used below VB script code available on lots of excel forums

       

      <code>

      ActiveSheet.Shapes.AddTextEffect(msoTextEffect1, strWord, "Arial Black", 36#, _

          msoFalse, msoFalse, 331.5, 198#)

      </code>


      but this code is not working in Qlikview..

      Any help on this...