Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Searching for files on disk
Resolved · Low Priority · Version 2003
Anna has attended:
Excel VBA Intro Intermediate course
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.
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
|
|
Excel tip:Highlighting only Text cellsTo select onlt text value cells in a spreadsheet, click on Edit-Go to(F5) |
TrustScore
4.8
/ 5
2236 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.07 secs.
