View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default I want a macro that can open a worksheet in a closed workbook

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