LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Filesearch no longer functions

Here is my code


Sub test2()
With Application.FileSearch
.NewSearch
.LookIn = "C:\ClipArt"
.SearchSubFolders = True
.FileType = msoFileTypeAllFiles
End With
end with


after i run this i put all the found file names into a textfile, or try to,
this code does ABSOLUTELY NOTHING. the starting directory does exist,
changeing the directory does NOTHING. there are some eight thousand files in
that directory, it worked fine the first time I ran the code. I changed the
directory to lookin and nothing not a thing. I rebooted my computer and ran
it again, nothing happened. I put in a different workbook, nothing happened,
I can not figure out why it ran once then just stopped no matter what i did,
anyone have some thoughts for my Manic Depressive code up there?
Ben
 
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
2003 functions no longer functional in 2007 Connie-UTHSCSA[_2_] Excel Worksheet Functions 5 August 7th 09 06:00 PM
List of Features/Options/Functions No Longer Available in XL 2007 monir Excel Discussion (Misc queries) 1 August 2nd 08 04:13 PM
Excel 2007 labels in functions no longer supported! forAbetterWorld Excel Worksheet Functions 14 March 6th 07 04:16 PM
Excel 2007 Beta - help no longer functions David Cox Excel Discussion (Misc queries) 3 August 20th 06 03:12 PM
Erase & Draw Border functions no longer work bob m Excel Discussion (Misc queries) 2 February 25th 05 06:03 PM


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

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

About Us

"It's about Microsoft Excel"