ExcelBanter - Open excel file and reffer to specific worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Open excel file and reffer to specific worksheet (https://www.excelbanter.com/excel-programming/400863-open-excel-file-reffer-specific-worksheet.html)

Arne Hegefors

Open excel file and reffer to specific worksheet

Hi! I have a macro that opens an excel file and activates it. How do I get it
to start at a certain worksheet?

Workbooks.Open "X:\SCD_RiskManager_Pos\RMDBII\test.xls" 'open file
Workbooks("test.xls").Activate 'ACTIVATE FILE

Gary''s Student

Open excel file and reffer to specific worksheet

Sheets("Sheet3").Select
--
Gary''s Student - gsnu200755

All times are GMT +1. The time now is 07:34 PM.