Refer to 1st Sheet, irrespective of name

[TimTDP]

In Access, I use the following to refer an Excel file:

Dim xlApp As Excel.Application
Dim xlWB As Excel.Workbook
Dim xlWS As Excel.Worksheet

Set xlWB = Workbooks.Open(filename)
Set xlApp = xlWB.Parent
Set xlWS = xlWB.Worksheets("Data")

How can I refer to the first worksheet, irrespective of its name?

Thanks in advance

 

[taurean]

Try something like:

Set xlWS = xlWB.Worksheets(1)

 

[TimTDP]

Thank you