How to use the same Excel sheet for 2 different Actions?

[Uma]

Hi,
I am using one Excel sheet(It has 9 pages,1st page for action 1 and all the other 8 pages for Action 2).
Both the Actions are Reusable.
If I run my script the First Action opens the Excel sheet and it works fine.
My code for first action

Code:

Set xlWrkbk = xlApp.Workbooks.Open("C:\ListMan.xls")
Set xlWrksht = xlWrkbk.Worksheets("MyDraft") ........

If it comes to the second Action,it gives the following error
Object required: 'xlWrkbk'

Because I didn't use the line

Code:

(Set xlWrkbk = xlApp.Workbooks.Open("C:\ListMan.xls"))

This is my script for second Action.

Code:

Set xlApp = GetObject("","Excel.Application")
If  Not xlApp  Is Nothing Then
Msgbox "ExcelSheet  is already open"
Else
Set xlApp = GetObject("","Excel.Application")
xlApp.visible = true
Set xlWrkbk = xlApp.Workbooks.Open("C:\ListMan.xls")
End If

Set xlWrksht = xlWrkbk.Worksheets("MyLi-Loc")

I used only the following line.

Code:

Set xlWrksht = xlWrkbk.Worksheets("MyDraft") ........

How to use the same Excel sheet for different Actions,without opening and closing againa nd again.
Any help?
Thank you
Uma

[rajpes]

use "Importsheet" method


action2 script:

Code:

Datatable.Importsheet("C:\ListMan.xls","MyDraft1",Action2)
its code here

Datatable.Importsheet("C:\ListMan.xls","MyDraft2",Action2)
its code here
.
.


Datatable.Importsheet("C:\ListMan.xls","MyDraft8",Action2)

[Uma]

Hi Raj,
Thank you for the solution
the code is working,but I did a small modification,
DataTable.ImportSheet "C:\ListMan.xls","Excelsheetname","actionname"
Uma

[rajpes]

that is what i meant dear