Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Does not work ApplyTheme in macro

Hi,

please, see my macro sub:

sub new_sheet

  set newsheet=ActiveDocument.CreateSheet

  set sp=newsheet.GetProperties

  sp.Name="New Sheet"

  newsheet.setProperties sp

  newsheet.ApplyTheme "d:\Program Files (x86)\QlikView\Themes\forest.qvt"

  newsheet.Activate

end sub

Error on newsheet.ApplyTheme... line

When I comment this line, the macro runs without error

PS. I copied the forest.qvt file to the c:\, but the operator

newsheet.ApplyTheme "c:\forest.qvt"

is still not working

0 Replies