Any way to open an excel file directly to a worksheet?

[skiddyrow]

I am building an application with an icon that launches an excel file when clicked. Is there any way I can open the file directly to a specified worksheet? The names of the worksheet are fixed and so is the file, so I am guessing adding some parameter after the filename should do the trick. Any help will be appreciated.

Regards

Sid

[Anne Troy]

Hey, Sid. Yes. See if this does it for you:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=338

*******************
~Anne Troy

www.OfficeArticles.com



"skiddyrow" <[email protected]> wrote
in message news:[email protected]...
>
> I am building an application with an icon that launches an excel file
> when clicked. Is there any way I can open the file directly to a
> specified worksheet? The names of the worksheet are fixed and so is the
> file, so I am guessing adding some parameter after the filename should
> do the trick. Any help will be appreciated.
>
> Regards
>
> Sid
>
>
> --
> skiddyrow
> ------------------------------------------------------------------------
> skiddyrow's Profile:
http://www.excelforum.com/member.php...o&userid=23965
> View this thread: http://www.excelforum.com/showthread...hreadid=386335
>

[Dave Peterson]

You could use a macro that runs when you open the workbook.

Option Explicit
Sub auto_open()
Application.Goto Worksheets("sheet1").Range("a1"), scroll:=True
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

skiddyrow wrote:
>
> I am building an application with an icon that launches an excel file
> when clicked. Is there any way I can open the file directly to a
> specified worksheet? The names of the worksheet are fixed and so is the
> file, so I am guessing adding some parameter after the filename should
> do the trick. Any help will be appreciated.
>
> Regards
>
> Sid
>
> --
> skiddyrow
> ------------------------------------------------------------------------
> skiddyrow's Profile: http://www.excelforum.com/member.php...o&userid=23965
> View this thread: http://www.excelforum.com/showthread...hreadid=386335

--

Dave Peterson