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

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

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" wrote
in message ...

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

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