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

 

[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