Shortcut to open an excel file

R

Ray

I need to create a shortcut on the desktop to open an excel file in a
folder. The first part of (about 10 characters) the file name is always the
same but the rest is changed each file. Is there any way to create such
shortcut? I tried to use xxxx*.* without success. Your advice is
appreciated.

Thanks,

Ray
 
S

Steve Yandl

Ray,

Are you trying to open multiple workbooks having similar names all at the
same time?

Since the file should exist when you create a shortcut to it, why not just
use the actual file name?

Steve
 
D

Dave Peterson

Could you just create a shortcut to the folder and then choose the correct
workbook from there?
 
R

Ray

Dear Steve,

Please see my reply as below. Thanks!

Steve Yandl said:
Ray,

Are you trying to open multiple workbooks having similar names all at the
same time?
Click to expand...

No, not really. I need to open one Excel file but the file names in the
folder are similar. For example, Minutes wk 21 11-11-03.xls, Minutes wk 22
18-11-03.xls, etc. However, last week, I needed to open the first file and
this week open the second file using the same shortcut.
Since the file should exist when you create a shortcut to it, why not just
use the actual file name?
Click to expand...

When I created the second file, the first file will be moved to other
folder. I just do not want to change the shortcut every week.
 
S

Steve Yandl

You can write a script in Visual Basic Script or Javascript that will look
for files in a given folder and launch those that meet a certain set of
criteria. Then you can make a shortcut to that script. I don't think there
is a way you can create a lnk file that would directly open any of a set of
files in a target location. Dave Peterson makes a very sensible suggestion
that would link you to a target folder which, based on what you've said,
would only expose one or very few xls files to choose from.

Steve
 
Top