Convert macro of VBS in JScript

Thu, 22 Aug 2013 09:32:07 GMT

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.

Re: Convert macro of VBS in JScript

Siva_Sankar — Thu, 22 Aug 2013 11:27:09 GMT

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

Thu, 22 Aug 2013 12:54:42 GMT

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