Open file to a specific worksheet

[Guest]

I have an MS Access database that points to a specific Excel file that has 10 spreadsheets. Is there any way to address the file so that it will open a specific tab? My filename is D:budgetmonthly_report.xls (this file has multiple tabs Jan, Feb, etc..) Can you address the file name with month name so that specific tab is what opens?

Thanks for any help. Paul

 

[Al Chara]

In the code for the ThisWorkbook add in the following code and subsitute Jan for whatever month you want to open:

Private Sub Workbook_Open()
Worksheets("Jan").Select
End Sub

I hope this helps.
Kind regards, Al.