I've been having a real annoying problem.  I want to obtain access
to a paticular sheet in a workbook containing a number of sheets.

    I can get VB to open the excel workbook, but it wont go to the one
sheet that I want the user to have access to.

   Any ideas?

                         TIA,

                                 Martin.

dim xlbook as Excel.Workbook
dim xlsheet as Excel.WorkSheet

Set xlbook = xlApp.Workbooks.Open(strFilePath)
Set xlsheet = xlbook.Worksheets(strSheetName)