Open specific worksheet from Access VBA

[SltPhx]

Hello All,
I am trying to open a pecific worksheet in an excel workbook from an access form.
The form has a contro 'ControlCharts' - And 'on Click' I want to add a VBA to open this specific worksheet from a folder on my desktop.
I am able to open the workbook - but not the specific worksheet.
This is the code I used -

Private Sub ControlCharts_Click()
Set xlApp = CreateObject("Excel.Application")


xlApp.Visible = True
xlApp.Workbooks.Open "Path", True, False
Set xlApp = Nothing
End Sub

Kindly let me know the answer to this. Thanks in advance

[manic]

You can try something like this:

Private Sub CmdOpenExcelSheet_Click()
On Error GoTo Err_CmdOpenExcelSheet_Click


  Dim xlApp As Excel.Application
  Dim xlWkbk As Excel.Workbook
  Dim xlSht As Excel.Worksheet


  Set xlApp = New Excel.Application


  xlApp.Visible = True
  
'Set the workbook and the filepath 'Change "C:\YourExcelFile.xls " to your own filepath and Workbook name
  Set xlWkbk = xlApp.Workbooks.Open("C:\Book1.xls ")

'Set the worksheet that you want the workbook to open on
  xlApp.Sheets("Sheet3").Select
  
 'Turn everything off otherwise you will have problems with your spreadsheet
  Set xlApp = Nothing
  Set xlWkbk = Nothing
  Set xlSht = Nothing
  
Exit_CmdOpenExcelSheet_Click:
    Exit Sub

Err_CmdOpenExcelSheet_Click:
    MsgBox Err.Description
    Resume Exit_CmdOpenExcelSheet_Click
    
End Sub

[SltPhx]

Thank you so much That worked.

I had to remove

Dim xlApp As Excel.Application
Dim xlWkbk As Excel.Workbook
Dim xlSht As Excel.Worksheet

And use
Set xlApp = CreateObject("Excel.Application")

Do you know the reason? I am not very familiar with VBA coding. Please explain if you do know, why.
Thank you so much for your time and effort. I really appreciate it.

[pbaldy]

You're using late binding, perhaps unintentionally; manic is using early binding, which requires a reference be set:

http://support.microsoft.com/default...;en-us;Q245115

[SltPhx]

Thank you so much Paul.
That link was helpful.
How will I mark this as solved?

[pbaldy]

No problem. You can mark the thread solved using "Thread Tools" near the top of the page.