Another Files search Question....

UniversalJOC · Feb 26th, 2002, 01:54 AM

whilst file search is performing a search in a particular folder, is there a way to omit a sub folder from that search?
Thanks

dk · Feb 26th, 2002, 02:21 AM

I take it you're using the code I gave you earlier? If so, then you can either choose to have all subfolders searched or no subfolders searched - you can't omit some folders but include others. To omit all subfolders do something like this:-

.SearchSubfolders=False

If you want something else then please be a tad more specific i.e. which folders do you want to include/exclude?

Regards,
D

UniversalJOC · Feb 26th, 2002, 02:54 AM

The only thing now is that the file names and locations that are the result of the search are logged in A1 downwards. Is there a way to stop this record being made and just open the appropriate files? (So that the button can be used over without having to delete the data? if this makes any sense)

dk · Feb 26th, 2002, 03:27 AM

Just take out the line that says

Cells(lngLoop,1) blah blah

D

UniversalJOC · Feb 26th, 2002, 05:36 AM

Ok, instead of not listing the file names found, is it possible to choose where they are displayed? and then clear them once they have been used?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 01:54 AM	#1
UniversalJOC New Member Join Date: Feb 2002 Posts: 40	whilst file search is performing a search in a particular folder, is there a way to omit a sub folder from that search? Thanks

Feb 26th, 2002, 02:21 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	I take it you're using the code I gave you earlier? If so, then you can either choose to have all subfolders searched or no subfolders searched - you can't omit some folders but include others. To omit all subfolders do something like this:- .SearchSubfolders=False If you want something else then please be a tad more specific i.e. which folders do you want to include/exclude? Regards, D

Feb 26th, 2002, 02:54 AM	#3
UniversalJOC New Member Join Date: Feb 2002 Posts: 40	The only thing now is that the file names and locations that are the result of the search are logged in A1 downwards. Is there a way to stop this record being made and just open the appropriate files? (So that the button can be used over without having to delete the data? if this makes any sense)

Feb 26th, 2002, 03:27 AM	#4
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Just take out the line that says Cells(lngLoop,1) blah blah D

Feb 26th, 2002, 05:36 AM	#5
UniversalJOC New Member Join Date: Feb 2002 Posts: 40	Ok, instead of not listing the file names found, is it possible to choose where they are displayed? and then clear them once they have been used?