Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Open file to a specific worksheet

  1. #1
    Guest

    Default

    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. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •