After your Workbooks.Open insert:
Sheets("sheet6").Activate
--
Gary''s Student - gsnu200753


"Joel" wrote:

Hi I was wondering what the VBA code was for opening a specific sheet in
another unopen workbook.

For example from one workbook I want to open sheet6 on another one

my code is beneath

Workbooks.Open "\\Kerrygriffit-pc\external\Other\Money\New Going out Sheet
V2.xls\february"

Thanks Joel


--
N/A