I know jim but i want to reference certain cells in that sheet and i need to
be able to open it at that sheet not any other in the workbook
--
BD3


"Jim Thomlinson" wrote:

Sheets are contained within books. You have to open the book to get the
sheet...
--
HTH...

Jim Thomlinson


"bigdaddy3" wrote:

I would like to write a macro that will open a particular worksheet in a
closed workbook that contains named sheets,when i use the application.open
route with the path details, i can get the whole book to open but i want a
particular sheet of that book. Can anyone help please
--
BD3