quote:

---

1) Move the selected worksheets to the same project folder and use the LabTalk's doc -ef or Origin C's foreach to operate on all in that folder.

...See toolbar discussion in the topic http://www.originlab.com/forum/topic.asp?TOPIC_ID=3412 .

---

void GetWksList(StringArray &sa)
{
	Folder fld = Project.ActiveFolder();
	foreach(PageBase pg in fld.Pages)
		if( pg.GetType() == EXIST_WKS )
			sa.Add(pg.GetName());
}

void MyWksFunction()
{
	StringArray sa;
	GetWksList(sa);
	Worksheet wks;
	for(int i=0;i<sa.GetSize();i++)
	{
		wks.Attach(sa[i]);
	// manipulation code goes here
	}
}

void GetWksList(StringArray &sa)
{
	foreach(PageBase pg in Project.Pages)
		if( pg.GetType() == EXIST_WKS )
			sa.Add(pg.GetName());
}

void Test1()
{
	foreach (WorksheetPage Wkp in Project.WorksheetPages)
	{
		Worksheet Wks(Wkp.GetName());
		if(Wks.IsValid())
		{
			// All Worksheets in Project
		}
	}
}

void Test2()
{
	Folder Fld=Project.ActiveFolder();
	foreach (PageBase pB in Fld.Pages)
	{
		Worksheet Wks(pB.GetName());
		if(Wks.IsValid())
		{
			// All Worksheets in CurrentFolder
		}
	}
}