Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.FileSearch
Has something changed in Excel 2002 (or XP) such that
the .FileSearch Property no longer works as it had in Excel 2000? The FileSearch no longer returns the correct results from a search. For example, the code listed below only returns the .html files listed on my C drive. Searches for "*.doc" or "*.xls" always return empty. With Application.FileSearch .NewSearch .LookIn = "C:\" .SearchSubFolders = True .Filename = "*.*" .MatchTextExactly = True .FileType = msoFileTypeAllFiles .Execute End With Any thoughts? In searching this newsgroup, there was only 1 question (posted 10/22/03) similar to this and it was never answered. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
.FileSearch
Randall
Check out this thread from google search. Consensus is that WinXP is a bit buugy when it comes to FileSearch. http://snurl.com/33mw Gord Dibben XL2002 On Fri, 21 Nov 2003 15:16:14 -0800, "Randall" wrote: Has something changed in Excel 2002 (or XP) such that the .FileSearch Property no longer works as it had in Excel 2000? The FileSearch no longer returns the correct results from a search. For example, the code listed below only returns the .html files listed on my C drive. Searches for "*.doc" or "*.xls" always return empty. With Application.FileSearch .NewSearch .LookIn = "C:\" .SearchSubFolders = True .Filename = "*.*" .MatchTextExactly = True .FileType = msoFileTypeAllFiles .Execute End With Any thoughts? In searching this newsgroup, there was only 1 question (posted 10/22/03) similar to this and it was never answered. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
.FileSearch
Hi Randall
You can try .xls or .doc You can also use the Dir function I use it in some examples on my site, maybe you can use it http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Randall" wrote in message ... Has something changed in Excel 2002 (or XP) such that the .FileSearch Property no longer works as it had in Excel 2000? The FileSearch no longer returns the correct results from a search. For example, the code listed below only returns the .html files listed on my C drive. Searches for "*.doc" or "*.xls" always return empty. With Application.FileSearch .NewSearch .LookIn = "C:\" .SearchSubFolders = True .Filename = "*.*" .MatchTextExactly = True .FileType = msoFileTypeAllFiles .Execute End With Any thoughts? In searching this newsgroup, there was only 1 question (posted 10/22/03) similar to this and it was never answered. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
.FileSearch
Not tested but try commenting out this line
.FileType = msoFileTypeAllFiles -- Don Guillett SalesAid Software "Randall" wrote in message ... Has something changed in Excel 2002 (or XP) such that the .FileSearch Property no longer works as it had in Excel 2000? The FileSearch no longer returns the correct results from a search. For example, the code listed below only returns the .html files listed on my C drive. Searches for "*.doc" or "*.xls" always return empty. With Application.FileSearch .NewSearch .LookIn = "C:\" .SearchSubFolders = True .Filename = "*.*" .MatchTextExactly = True .FileType = msoFileTypeAllFiles .Execute End With Any thoughts? In searching this newsgroup, there was only 1 question (posted 10/22/03) similar to this and it was never answered. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
.FileSearch
-----Original Message----- Hi Randall You can try .xls or .doc You can also use the Dir function I use it in some examples on my site, maybe you can use it http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Randall" wrote in message ... Has something changed in Excel 2002 (or XP) such that the .FileSearch Property no longer works as it had in Excel 2000? The FileSearch no longer returns the correct results from a search. For example, the code listed below only returns the .html files listed on my C drive. Searches for "*.doc" or "*.xls" always return empty. With Application.FileSearch .NewSearch .LookIn = "C:\" .SearchSubFolders = True .Filename = "*.*" .MatchTextExactly = True .FileType = msoFileTypeAllFiles .Execute End With Any thoughts? In searching this newsgroup, there was only 1 question (posted 10/22/03) similar to this and it was never answered. . I have encountered a similar problem. I have many Office 2000 vba programs using Application.Filesearch and Foundfiles.count, non of them work in Office 2002. The returned count is always zero. I have gotten around this by running the code on an Office 2000 system and mapping to the Office 2002 files. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.FileSearch | Excel Discussion (Misc queries) | |||
FileSearch in a combo box | Excel Discussion (Misc queries) | |||
FileSearch Problem | Excel Programming | |||
FileSearch Code | Excel Programming | |||
FileSearch Problem | Excel Programming |