Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Madhu,
Follow link in the attachment.
Thanks,
AS
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/
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
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