Open excel 2007 with a certain worksheet
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
|