Vba: Opening a specific sheet in a workbook

[bamaisgreat]

Thanks for looking at my post. I am trying to create a macro to open a specific workbook on a specific sheet. This is the file path were the workbook is located.



H:\Burney Table\BURNEY 2\Operators Form\Burney2.xls

 

[VoG]

Try like this

Workbooks.Open Filename:="H:\Burney Table\BURNEY 2\Operators Form\Burney2.xls"
Sheets("Sheet1").Select

 

[Andrew Poulsom]

Use the Open method to open the workbook. It will then become the ActiveWorkbook, so to activate Sheet1:

ActiveWorkbook.Worksheets("Sheet1").Activate

 

[bamaisgreat]

Thank you all, Greatly Appreciated