Origin Ver. and Service Release (Select Help-->About Origin): V8.0 SR0
Operating System:XP
anybody knows how to move a worksheet inside a workbook by using a script?
i tried to treat it as a layer but it seems it is not working.
i have a workbook containing several datasets with the names Aii. the workbooks are indexed with ascending numbers but some of the worksheets are missing (eg. A1, A2, A7, A9 etc.) i want to create a loop which will check if Aii is present, else a new worksheet is created then it should be activated and then moved to the corresponding position in the workbook. i use this script to create and activate the layer but i cannot move the newly created empty workbook from the last position.
newsheet n:=A$(ii) c:2; book$(jj)!page.active$ = "A$(ii)"; book$(jj)!page.reorder($(ii))
does anybody have a suggestion?
regards
set position index for worksheet
Posted - 08/26/2010 : 1:22:53 PM
