How to get more than one Local DataTable sheet for one Action?

[Uma]

Hi,
I have a 6 Pages in Excel and I have 3 Actions,so QTP gives 3 sheets in the local data table.
1 Page details are used by Action1.
2 Page details are used by Action2.

The another 4 Excel Pages are used by Action3.It has more than 25-30columns.
So I want to use 4 different Pages in the local dataTable.[Again I dont want to divide this as a 4 Actions,because all these data needs to work together.]
Is it possible?or QTP will provide only one Page for one Action?

Any help?
Thank you,
Uma

---

Solved by using following,
DataTable.AddSheet("xyz")

[rajpes]

As i gave a hint to your previous problem, you can dump any sheet from excel at any point of run time

Datatable.importsheet filename,4,action3
work with it

Datatable.importsheet filename,5,action3
work with it

***************
or better you create workbook objects through excel com (createobject("excel.application"))

[Uma]

Thank you,
It am dumping the sheet from excel..
Uma