VBA - Visual Basic for Applications
Whenever you have a list of unique key values identifying one file in a directory, but the file name contains other text as well it is possible to use wildcards in order to open the file you want.
Below code snippet will do the trick for you.
The function Dir() returns an empty String (""), in case a file could not be identified. Therefore you will need extra handling for this case.
In case more than one file was identified by Dir(), only the first file (whichever the first may be) is returned.
- Hits: 3260
If you ever wondered how to determine, if an opened workbook was saved before below you'll find a code snippet that might do the job for you.
- Hits: 3126
I am Mr. Forgetful. What was this password again?
Anyway, if you do not know any better, use brute force!
- Hits: 3223
Excel VBA Article Count: 30
This category will hold articles regarding developement in Excel VBA. It will serve as a wiki and an Excel VBA Framework for myself.
Some development tasks reoccur for every customer. Since I am a lazy bum it will be nice to have a central source where I can reuse source code from.
MS Office and VBA Article Count: 11
This category holds articles regarding general things in MS Office VBA independent from the MS Office application.
Power Point VBA Article Count: 1
Page 11 of 17