You are currently browsing all posts tagged with programming

PowerBuilder ‘Gotcha’ – PixelsToUnits

Posted on September 7, 2011 at 8:20 pm in

From the Powerbuilder Help on this method: Converts pixels to PowerBuilder units. Because pixels are not usually square, you also specify whether you are converting the pixels’ horizontal or vertical measurement. Syntax PixelsToUnits ( pixels, type ) Argument Description pixels An integer whose value is the number of pixels you want to convert to PowerBuilder…

PowerBuilder ‘Gotcha’ – PixelsToUnits - the full story »

PowerBuilder – Reading Outlook Items

Posted on September 1, 2011 at 8:20 pm in

Here is some code which reads data from Outlook (2007 was tested) into PowerBuilder. You basically need to create a window with a multiline edit and a button on it. Put this into the clicked event of the button. To run it, open Outlook, select something (email message, task, etc.) then click the button on…

PowerBuilder – Reading Outlook Items - the full story »

PowerBuilder – Grid datawindow object with variable number of columns

Posted on August 17, 2011 at 8:20 pm in

Here is a way to build a grid datawindow which contains columns corresponding to an unknown number of data elements. You could use this approach in creating a project schedule, inventory location system, baseball box score, or any number of other examples. My example assumes the minimum number of columns to be four. This create…

PowerBuilder – Grid datawindow object with variable number of columns - the full story »

PowerBuilder – Selecting and scrolling to an entry in a Listview control

Posted on August 17, 2011 at 8:20 pm in

The listview control in PB lacks the capability to scroll to a highlighted item within the native Powerscript. Here is an easy way to do this by simulating key strokes. First declare the following API subroutine. keybd_event( int bVk, int bScan, int dwFlags, int dwExtraInfo) Library "user32.dll" Next create a user event in the listview…

PowerBuilder – Selecting and scrolling to an entry in a Listview control - the full story »

VBA – Processing ICS calendar file attachments

Posted on July 27, 2011 at 8:20 pm in

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 – Processing ICS calendar file attachments - the full story »

Comment on VBA – Processing ICS calendar file attachments »

VBA – Reading a file into an array and Appending to a file

Posted on July 11, 2011 at 8:20 pm in

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 – Reading a file into an array and Appending to a file - the full story »

VBA – Removing attachments from Outlook email

Posted on July 1, 2011 at 8:20 pm in

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…

VBA – Removing attachments from Outlook email - the full story »

Look what I found – Part 3

Posted on June 30, 2011 at 8:20 pm in

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?

Look what I found – Part 3 - the full story »

Using ICalendar (.ICS) files for Event Scheduling

Posted on June 24, 2011 at 8:20 pm in

Here is a very easy way to schedule events from within your application. This assumes you have a way to send emails with attachments. If you are dealing with a high volume situation, you may with to write the data to a table and have the database (or some other process) send them out. The…

Using ICalendar (.ICS) files for Event Scheduling - the full story »

PowerBuilder – Folder Selection Dialog Window

Posted on June 23, 2011 at 8:20 pm in

Here is an NVO used to envoke a Windows folder selection dialog since PowerBuilder does not have it’s own version. You can change the API calls to ANSI for earlier versions of PB. I’ve had this squirreled away for awhile and I no doubt got it from someone else off the web. Thanks! // window…

PowerBuilder – Folder Selection Dialog Window - the full story »

Top