VBA - Visual Basic for Applications
Ever since I am working in roles providing technical support for Identity and Access Governance, I am often confronted with the need of printing and archiving a lot of mails for audit trail.
I do despite this task not only because it is annoying but also because there are much better ways for documenting audit proof history than using a document based system.
Anyway ... Since this task is annoying I wrote a little script in VBA to print all selected emails.
This will go into a class called PdfPrinter. It utilizes MS Word in order to print /convert emails to PDF.
Utilizing MS Word is not the best option since the other Application has to be handled properly in order to close Word properly after the job is done. Else you are facing lost references and the application stays open in RAM and the user does not even see it is still running.
- Hits: 2379
In case you need the selected list item from a listbox, which only allows single selection the selected list item can be returned using the below source code.
Where listBox is the name of the control element / the listbox as you defined it.
Me refers to a form a listbox is placed in.
The column index within a listbox is zero based.
- Hits: 2126
If you have to delete all records from a table using Access VBA DAO, the following method might be helpful.
- Hits: 2183
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 16 of 17