This article describes the techniques and code used during my presentations at the Carolina Code Camp 2012 and at the May 2012 meeting of the North Carolina PowerBuilder User Group. The techniques described here utilize Visual Basic .Net (coded in Visual Studio 2010) with the Interop Forms Toolkit available from Microsoft. The Interop Forms Toolkit…
You are currently browsing the Visual Basic category
PowerBuilder – Using .Net Visual Controls in PB Classic Applications
VBA – Processing ICS calendar file attachments
This article brings to conclusion the Outlook VBA macro/script I wrote to process event scheduling attachments (.ICS or ICalendar files). The first article shows how to process emails and remove their associated attachments. The second shows how to open the files and both read the file contents into an array as well as write (append)…
VBA – Reading a file into an array and Appending to a file
Both of these routines can be called from Outlook Macros/Scripts to process files. In my case I am using them to open iCalendar (ICS) files and place the contents into a string array. The calling method then processes the information then flags the file as ‘PROCESSED’ by the second routine. Public Sub icsFileToArray(ByVal FileName As…
VBA – Removing attachments from Outlook email
One very powerful aspect of the Microsoft Office Suite of applications is the ability to create Macros and Scripts to perform various processes. This gives those of us who worked in Visual Basic 6 a chance to dust off our skills since the ‘flavor’ of Visual Basic used in the Microsoft Office applications (aptly called…
Look what I found – Part 3
Found on a Microsoft Answers forum: Hello? Microsoft? your help files are of no help. Does anyone really bother to participate in any of those obnoxious ‘Help us improve’ programs?