VBA - Visual Basic for Applications
The below method will replace all special or escape characters in a provided String.
This is of use, if you have to use before unknown Strings from any source for example in a file name.
- Hits: 8474
Below method allows you to remove the shadow from all shapes of the same type (arrow, rectangle, ... ) at once, instead of selecting each shape manually.
If you want to apply more formats than only removing a shadow, then use the methods PickUp and Apply of the Shape object.
PickUp copies the format of one Shape object and Apply copies a before picked up format.
- Hits: 8200
The following method exports all available queries in an Access database into individual text files, which are called like the corresponding query.
DAO does not provide the support ADODB gives you, therefore this method will only work with queries created and stored in a current MS Access database.
The method writeLineToTextFile is not a standard VBA method, but can be found at following URL.
The target encoding should not be UTF-16LE but ASCII, if you intend to use a versioning tool like GIT to keep track of changes in MS Access queries.
Replacing special characters can be a pain, if you do not rely on regular expressions.
Delete a file on a users hard disc (VBScript, which can easily be adjusted to VBA).
- Hits: 8447
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 3 of 17