Putting a loop on the "range" specification

[davey87]

Hello,

I have to export data from a workfile to an excel file with 120 different tabs. I am wondering if there is a way to put a loop on within the "range" specification, specifically to loop through the excel sheet number. It doesn't seem to be working for me. For example:

Code: Select all

for !i=1 to 120 pagesave(type=excel, mode=update, noid) "file.xls" range="Sheet{!i}!c3:ad122" nonames na=" " byrow @keep aios{!i} next

Any suggestions would be appreciated.

Thanks

[EViews Gareth]

Code: Select all

for !i=1 to 120 %sheet = "sheet" + @str(!i) + "!c3:ad122" pagesave(type=excel, mode=update, noid) "file.xls" range=%sheet nonames na=" " byrow @keep aios{!i} next