ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Locating a file in excel with a partial file name. (https://www.excelbanter.com/excel-discussion-misc-queries/14028-locating-file-excel-partial-file-name.html)

Audra

Locating a file in excel with a partial file name.
 
I have been runnimg with Office 2000 with which when I go to open a file in
excel I am able to enter a partial file name, any part of the file name, to
search for the file I wish to open. I am finding in Excel 2002 this function
does not apprear to exsit, only the function where it will search for the
fille that starts with what your typing will appear once its narrowed it down
to the first of a few possible options.

I require the ability to be able to just go to the file open icon in excel
and on the file name line be able to typr the last few chararacters of a file
name to find the file I want.

Has this function been removed from Excell 2002?

Dave Peterson

In xl2003, I can type a partial string and hit enter and only those files
containing that string will show in the File|open dialog.

I _thought_ that I had to type something like this in xl2002:

*ook*
hit enter
to see all the filenames that contain "ook"

You may find doing that less of an annoyance.

Audra wrote:

I have been runnimg with Office 2000 with which when I go to open a file in
excel I am able to enter a partial file name, any part of the file name, to
search for the file I wish to open. I am finding in Excel 2002 this function
does not apprear to exsit, only the function where it will search for the
fille that starts with what your typing will appear once its narrowed it down
to the first of a few possible options.

I require the ability to be able to just go to the file open icon in excel
and on the file name line be able to typr the last few chararacters of a file
name to find the file I want.

Has this function been removed from Excell 2002?


--

Dave Peterson


All times are GMT +1. The time now is 06:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com