![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
|
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Monterrey, Mexico
Posts: 1,433
|
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. |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|