Does Select Case support wildcards? The short answer is no.
However, Select Case (and any other conditional statement evaluating strings) looks for matches, and if your match is "find computer name beginning with OFFICE," then Select Case will only choose that option if it finds a computer named OFFICE* -- complete with asterisk.
The Left or Right functions can be used to pull either the leftmost or rightmost characters from a string. To use these functions, supply the string (either explicitly or assigned to a variable) and the number of characters you want as arguments. For example, Left("Computer",3) returns "Com." If your computer naming convention works well with wildcards, then assign the results of this function to a variable and use Select Case to test against those results.
Scripting School: More on connecting to network resources
What happens to all those mapped drives?
What about location-based mappings?
How do I map printers?
Does Select Case support wildcards?
How to put the script together
MapResources sample script
|ABOUT THE AUTHOR:|
| Christa Anderson
When Christa Anderson began working with Windows Server operating systems in 1992, she became increasingly interested in finding more efficient and flexible ways of performing routine tasks. Christa has written extensively about administrative scripting and taught technical sessions on the subject at conferences such as Comdex and CeBIT, helping people who had never done any scripting to write their own scripts in half a day. In addition to her interest in scripting Windows management, Christa is an authority on server-based computing and the program manager for Terminal Services licensing in Longhorn. If you have a scripting question for Christa, please e-mail her at scripting@SearchWinSystems.com.