Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default FileSearch Excel 2007

Hello, is there a File Search command in Excel 2007 please?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default FileSearch Excel 2007

Application.filesearch was removed with xl2007.

Ron de Bruin shares some alternatives he

http://www.rondebruin.nl/fso.htm
and
http://www.rondebruin.nl/copy3.htm

shaz wrote:

Hello, is there a File Search command in Excel 2007 please?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default FileSearch Excel 2007

You may also consider the work-around using the FileSystemObject object.
http://support.microsoft.com/kb/185601
Micky


"shaz" wrote:

Hello, is there a File Search command in Excel 2007 please?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default FileSearch Excel 2007



"Dave Peterson" wrote:

Application.filesearch was removed with xl2007.

Ron de Bruin shares some alternatives he

http://www.rondebruin.nl/fso.htm
and
http://www.rondebruin.nl/copy3.htm

shaz wrote:

Hello, is there a File Search command in Excel 2007 please?


--

Dave Peterson
.
But how does a user not wanting to use programming language search for a file in 2007?

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default FileSearch Excel 2007

I've always searched for files using windows search (ctrl-f in windows
explorer).

shaz wrote:

"Dave Peterson" wrote:

Application.filesearch was removed with xl2007.

Ron de Bruin shares some alternatives he

http://www.rondebruin.nl/fso.htm
and
http://www.rondebruin.nl/copy3.htm

shaz wrote:

Hello, is there a File Search command in Excel 2007 please?


--

Dave Peterson
.
But how does a user not wanting to use programming language search for a file in 2007?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 to 2007 Macro containing "Filesearch" dede Setting up and Configuration of Excel 3 December 4th 09 05:00 PM
Application.FileSearch Cleberton(Brazilian) Excel Discussion (Misc queries) 2 October 26th 09 01:21 PM
Excel 2007 files not showing on screen when opened in Excel 2007 [email protected] Setting up and Configuration of Excel 1 January 8th 09 05:45 PM
Lookin property of the FileSearch object [email protected] New Users to Excel 0 December 5th 06 09:37 PM
FileSearch in a combo box michaelberrier Excel Discussion (Misc queries) 0 June 16th 06 12:21 AM


All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"