The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 Loop through worksheets 2 onwards
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Clairekun

Germany
175 Posts

Posted - 08/14/2020 :  08:34:19 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 2018b
Operating System: Windows 10

Hello,

I have been trying to find a way to loop through worksheets 2 to end in the active workbook in order to plot them afterwards.

The command doc -e LW{} loops through al of them, but I was unsuccessfull at writing a for or loop command that included wks.index or page.active, since wks(i).index and page(i).active do not exist.

Could you please help? Thank you.

YimingChen

1669 Posts

Posted - 08/14/2020 :  08:53:53 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Can you simply use syntax below within the for loop to activate each sheet.
page.active=i;


James

Edited by - YimingChen on 08/14/2020 08:55:03 AM
Go to Top of Page

Clairekun

Germany
175 Posts

Posted - 08/14/2020 :  10:46:16 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Working now, thanks! So simple I feel embarrassed...
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000