help in vb codes (opening worksheets)

[hima00]

Hi all i am beginner in vb. could any one pls help me in vb code here. i want to open worksheet2 in worksheet1 by using vb code.

here is my code
Dim xlTmp As Excel.Applicati on

Set xlTmp = New Excel.Applicati on
xlTmp.Workbooks .Open "d:\Jiju-timesheet.xls"

Dim xlSht As Excel.Worksheet

xlSht = xlTmp.Worksheet s (error appear here saying the variable is not set)

[willakawill]

Hi. What happens if you do this?

Set xlSht = xlTmp.Worksheets