Opening A Specific Tab/Sheet in Excel

[nriacone]

I am using a maintenance application that allows me to attach a document to a work order. When the application prints the work order the attachment is part of the print job. The issue occurs because the Excel files that are associated with the work orders have multiple tabs/sheets within the file. Is there a method to open an Excel file to a specific tab/sheet so we will not have to split each tab/sheet into a separate file?

Thanks in advance.

 

[Dreamboat]

I don't know if it's the BEST method, but you can put this in the ThisWorkbook module of your VB Editor (Alt+F11):

Private Sub Workbook_Open()

Application.Goto Reference:="Sheet1!R[-1]C[-4]"

End Sub

Anne Troy

http://www.VBAExpress.com