How to use Run Macro in qlikview ?

[#1]

hi,

I Created Qlikview file.I created Macro In that file But the macro did not work ple tell me out how to solve that problem.

I do not know  how to create macro ple help me.I attached  script snipping file  and object snipping filebelow this box.

  Thank you

Regards:

Madhu

[amit_saini]

Madhu,

Follow link in the attachment.

Thanks,

AS

[#3]

hi

press ctrl M

then  write code as

******************************

Sub zoomfit0

.....

.....

......

end sub

********************************

then if you want this macro on button click then button properties--> action-->

run macro

macro name =zoomfit0

then ok

same for secomd macro/

[#4]

I FALLOWED DIRECTIONS BUT THE SCRIPT SHOW ERROR PLE HELP ME HOW TO SOLVE THIS PROBLEM

I WRITE SCRIPT LIKE THIS .SEE AND SOLVE MY PROBLEM.

***********************************

sub zoomfit0

  set mysheet = ActiveDocument.Activesheet

  set sp=mysheet.GetProperties

  sp.Zoomfactor=-1

  mysheet.Setproperties sp

ENDSUB

*******************************

sub zoomfit1

  set mysheet = ActiveDocument.Activesheet

  set sp=mysheet.GetProperties

  sp.Zoomfactor=1.35

  mysheet.Setproperties sp

  EndSub;

REGARDS:

MADHU

[#5]

I FALLOWED YOUR DIRECTIONS VISHWARANJANKUMAR  BUT THE SCRIPT SHOW ERROR PLE HELP ME HOW TO SOLVE THIS PROBLEM THANK YOU.

I WRITE SCRIPT LIKE THIS .SEE AND SOLVE MY PROBLEM.

***********************************

sub zoomfit0

  set mysheet = ActiveDocument.Activesheet

  set sp=mysheet.GetProperties

  sp.Zoomfactor=-1

  mysheet.Setproperties sp

ENDSUB

*******************************

sub zoomfit1

  set mysheet = ActiveDocument.Activesheet

  set sp=mysheet.GetProperties

  sp.Zoomfactor=1.35

  mysheet.Setproperties sp

  EndSub;

REGARDS:

MADHU

How to use Run Macro in qlikview ?