Searching for files on disk

Resolved · Low Priority · Version 2003

Anna has attended:
Excel VBA course

by - delegate Anna [1 post] (2008 Jul 17 Thu, 16:41) Reply

User provides a path and a name of a file, but a file with the name exactly as the user provided might not exist. However a very similar file exists. It might also happen that the file user asks for and a very similar one exist. How can I search for files with names similar to what the user asks for and if there are a few similar files -- open the one created the latest.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: searching for files on disk

by - trainer Roy bronze contributer [28 posts] (2008 Jul 21 Mon, 16:17) Reply

You could use the Like operator (check it out in online Help), which will match with a pattern. For example, the pattern "ABC*" matches all strings which start with "ABC".

/Roy