LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel startup switches Randy Excel Discussion (Misc queries) 9 June 14th 05 10:27 PM
Excel 2000 - file won't open giovanni Excel Discussion (Misc queries) 3 May 19th 05 01:32 PM
How Do I open an excel file without Excel Viewer support CocoriteBallGiants Excel Discussion (Misc queries) 2 February 4th 05 10:50 PM
Cannot open a file that Excel says is open Plodhia Excel Discussion (Misc queries) 2 December 7th 04 01:43 AM
Open a file in excel from a link in eplorer Dave Peterson Excel Discussion (Misc queries) 0 November 26th 04 01:25 AM


All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"