Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert macro of VBS in JScript

Hi, I need help to make a macro that is currently in VBS to JScript.

This macro enables/disables the scrollbar by a button:

sub View_Scroll

   set v=ActiveDocument.Variables("var_Scroll") ' var_Scroll => variable created in the environment qlikview

   if v.GetContent.string="0" then

     v.SetContent "1",false

     value = 1

   else

     v.SetContent "0",false

     value = 0

   end if

  

   dim c(1)

   c(0)="CH01"

   c(1)="CH02"

   for i=0 to 1

     set chart = ActiveDocument.GetSheetObject(c(i))

     set cp = chart.GetProperties

     cp.ChartProperties.XAxisScroll = value

      chart.SetProperties cp

   next  

end sub

Thanks.

2 Replies
Siva_Sankar
Master II
Master II

may i know for what purpose you are trying to conver the code to jscript?

Not applicable
Author

Hi Siva,

We go to migrated to access to documents with Ajax instead IE-Plugin.

I read that this type of macros not work well.

Thx.

Pedro