VBA - Visual Basic for Applications
If you need to know a files name from a file path it might be interesting to also know, if this file is alos existing.
Below you will find a method, which only returns a files name if the file is available in current file system.
Referenced APIs can be found below.
- Hits: 2933
Sometimes it is necessary to get a folder path from the user instead of receiving a file path.
The Excel Application class is providing a corresponding function, which is used in below method.
- Hits: 2838
If you search a value in a column in Excel the following method will be of use.
- Hits: 2875
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 14 of 17