Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Problem to Script execute the macro - macro to export sheets as image

hi everyone, I'm having an issue with Qlikview where my project have some sheets and I need that in the execution of my script, it execute the macro of my project where my macro will export an image of each one fom my sheets.

on my macro I have de code and te macro execute when I go Through the sheets.

the export function is working but is doesn't run when I execute the script.

can anyone help me??

2 Replies
Master III
Master III

You have to call the activate method of the sheet

ex:

ActiveDocument.Sheets("Market").Activate

set newsheet=ActiveDocument.CreateSheet

set sp=newsheet.GetProperties

sp.Name="abc"

newsheet.setProperties sp

newsheet.Activate

Contributor II
Contributor II

Sorry for the late post, but I figured out a while ago.

The case the macro didn't execute properly was becuse I was using the type of view where I could see all the sheets.

When I unselected the option Show all sheets and objects in Security on Document's properties it all went fine.