Shortcut to open an excel file

  • Thread starter Thread starter Ray
  • Start date Start date
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
 
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
 
Could you just create a shortcut to the folder and then choose the correct
workbook from there?
 
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.
 
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
 
Back
Top