Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel startup switches | Excel Discussion (Misc queries) | |||
Excel 2000 - file won't open | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Cannot open a file that Excel says is open | Excel Discussion (Misc queries) | |||
Open a file in excel from a link in eplorer | Excel Discussion (Misc queries) |