View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sunnose Sunnose is offline
external usenet poster
 
Posts: 4
Default Open excel 2007 with a certain worksheet

No, not from a macro. From a command prompt or from "scheduled activities"
------------------------------------
"Dave Peterson" skrev:

In a macro???

Option Explicit
Sub Auto_Open()
application.goto thisworkbook.worksheets("sheet9999").range("a1"), _
scroll:=true
End Sub

Sunnose wrote:

What is the start command syntax if I want to open a Excel 2007 workbook with
a certain worksheet ? ( Not the standard "Sheet1" )


--

Dave Peterson