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

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

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

How would excel/windows know what worksheet to start on--if you have 37 excel
workbook with scheduled activities--and each of those could have multiple
differently named worksheets.

In a specific workbook, you could use a macro to specify which worksheet to
start on.


Sunnose wrote:

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


--

Dave Peterson

Well, that´s what I would like to tell Excel in the command prompt.
For example: something like c:\program\excel.exe
c:\folder\myworkbook!sheet9999.xls
Perhaps it´s not possible ?

"Dave Peterson" skrev:

How would excel/windows know what worksheet to start on--if you have 37 excel
workbook with scheduled activities--and each of those could have multiple
differently named worksheets.

In a specific workbook, you could use a macro to specify which worksheet to
start on.


Sunnose wrote:

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


--

Dave Peterson

Put the sheet selecting macro IN the workbook. When the workbook opens
the desired sheet will be the active one.

Sunnose wrote:

Well, that´s what I would like to tell Excel in the command prompt.
For example: something like c:\program\excel.exe
c:\folder\myworkbook!sheet9999.xls
Perhaps it´s not possible ?

"Dave Peterson" skrev:


How would excel/windows know what worksheet to start on--if you have 37 excel
workbook with scheduled activities--and each of those could have multiple
differently named worksheets.

In a specific workbook, you could use a macro to specify which worksheet to
start on.


Sunnose wrote:

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


--

Dave Peterson