Opening to a file

  • Thread starter Thread starter amc
  • Start date Start date
A

amc

How can I set up Excel 2003 to open to a particular file. I have the Excel
Win XP shortcut pointing to the file but Excel still opens a blank file.
Thanks, CMA
 
If you want a specific Excel file to open when you open excel
application, then goto:

The path to Startup folder would similar to this:
C:\```Application Data\Microsoft\Excel\XLSTART

Windows Explorer, move the icon of the workbook you want to open to an
alternate startup folder.
If you want to keep the workbook in its current location, use the
Create Shortcut command on the File menu to create a shortcut to the
workbook, and then move the shortcut to an alternate startup folder.
Now, restart Excel.

Otherwise, if you want to change the program that starts when you open
a file, goto:
My Computer or Windows Explorer, click the Tools menu, click Folder
Options, and then click the File Types tab. In the Registered file
types list, click the file type you want to open with a different
program, and then click Change. In the Open With dialog box, select
the program you want to use, and then click OK. Click OK in the Folder
Options dialog box.

I hope this helps...

Selva V Pasupathy
For more resources on Excel, VBA, & other resources,
Please visit: http://socko.wordpress.com

Reference: Excel Help files.
 
Is your shortcut just a shortcut to the .xls file?

If yes...

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets some of the windows registry to
excel's factory defaults.
 
Back
Top