Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default How do you do a file search in XL2007

Hi,

Windows XP Home sp2 and Excel 2007

As MS have dropped Application.Filesearch in XL2007 is there any
method available that can search for files in folders / sub-folders

TIA for any help

Raymond

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default How do you do a file search in XL2007

http://msdn.microsoft.com/library/de...ce09072000.asp
Working with Files, Folders, and Drives: More VBA Tips and Tricks
by David Shank (Office talk)




http://support.microsoft.com/kb/185476/EN-US/
How To Search Directories to Find or List Files

http://support.microsoft.com/kb/185601/EN-US/
HOW TO: Recursively Search Directories by Using FileSystemObject

http://support.microsoft.com/kb/186118/EN-US/
How To Use FileSystemObject with Visual Basic

--
Regards,
Tom Ogilvy


" wrote:

Hi,

Windows XP Home sp2 and Excel 2007

As MS have dropped Application.Filesearch in XL2007 is there any
method available that can search for files in folders / sub-folders

TIA for any help

Raymond


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
file search or search files Richad Excel Discussion (Misc queries) 0 October 22nd 09 07:56 PM
Syntax for 'search' in Horizontal range? XL2007 ker_01 Excel Worksheet Functions 2 October 6th 09 04:11 PM
XL2007 - Can't open a file that is in use on the network PCLIVE Excel Discussion (Misc queries) 0 February 4th 09 07:30 PM
Editing a file on a webserver with XL2007 LeonIloilo Excel Discussion (Misc queries) 0 June 13th 08 08:17 PM
Turning a text file name into a search and linking the file as a hyperlink AlistairM Excel Discussion (Misc queries) 1 January 26th 06 04:55 AM


All times are GMT +1. The time now is 08:51 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"