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.
Source Code
Enjoy.
- Hits: 13283
If you want to export a collection of type Scripting.Dictionary into a text file the below function may come handy.
- Hits: 12176
The following method exports all available queries in an Access database into individual text files, which are called like the corresponding query.
Source Code
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.
Resources
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.
Write a String into a text file
Replacing special characters can be a pain, if you do not rely on regular expressions.
Replace special escape characters in String
Delete a file on a users hard disc (VBScript, which can easily be adjusted to VBA).
- Hits: 13116
Subcategories
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
Access VBA Article Count: 7
This category holds articles regarding Access VBA, but also general things I come accross Access and its usage in companies.
Access VBA DAO Article Count: 2
Page 2 of 17