WinFun v2.x has been certified ca smart with Advantage Gen from Computer Associates.

With the help of WinFun your application can:

• launch and manipulate other Windows applications (including the Advantage Gen Client Manager)

• find, hide, restore, resize, center, fix, freeze, bring to the top, close or send other messages to any Window or control on the desktop (including those in the current application)

• manage processes - launching, obtaining handles, verifying and terminating

• click buttons and menu items on any window

• implement dynamic menus, and automatic and custom popup menus

• print data and text files

• perform directory searches, create and delete directories

• retrieve file information, including sizes and date/time stamps to support versioning

• manipulate the clipboard

• manipulate profile (.INI) files

• monitor keyboard keys

• set the local system clock and perform timing functions

• return a variety of information about the system

• format strings and numbers

and many other functions (more than 100 in total).

WinFun gives you the power to do professional desktop integration. As an example, you could if you wished use WinFun to launch another application such as WordPad (having first determined whether it's already running or not), get a handle on its Edit window, copy information from your application into the clipboard, paste it into the WordPad window and bring it to the top of the desktop. Or you could launch the Client Manager in a hidden state when your application starts up, and terminate it when the application closes, so that the user never sees the Client Manager window at all unless there is a problem.

For more information and a full list of functions and examples, see the WinFun documentation.

To download RNWINFUN.DOC (Word 6.0 331k) click here

  

WordFun v2.x has been certified ca smart with Advantage Gen from Computer Associates.

With the help of WordFun your application can:

• determine if Word is running and return the Word window handle

• launch Word in any state (hidden, normal, minimized, maximized)

• open Word documents (optionally with password and/or read only)

• run Word macros

• create Word documents from text files (which can be created from within Advantage Gen applications)

• create Word tables from data contained in text files. If desired the tables can be embedded in Word template documents.

• create form letters based on Word templates

• perform Word MailMerges to produce merge documents or labels based on templates

• replace all occurrences of a string in an open document with another string.

• close Word

Using combinations of these powerful functions the developer can do most of the things he or she would normally need to do without needing to understand the Word object model or WordBasic. And WordFun functions include features that cannot otherwise be emulated from within Advantage Gen, including sophisticated error handling.

For more information and a full list of functions and examples, see the WordFun documentation.

To download RNWDFUN.DOC (Word 6.0 272k) click here

ExcelFun v2.x has been certified ca smart with Advantage Gen from Computer Associates.

With the help of ExcelFun your application can:

• determine if Excel is running and return the Excel window handle

• launch Excel in any state (hidden, normal, minimized, maximized)

• open and close Excel workbooks (optionally with passwords and/or read only)

• navigate workbooks, activating workbooks, worksheets and ranges. Create new workbooks, optionally based on pre-defined templates

• import data into Excel from text files (which can be created from within Advantage Gen applications). If desired the data can be embedded in Excel template workbooks.

• format Excel tables and defined ranges to create a sophisticated, custom look

• insert values, formulae and graphics into cells. Retrieve data from cells. Copy data and formulae from one part of a workbook to another.

• insert, delete and rename worksheets

• create a variety of different charts

• run Excel macros

• replace all occurrences of a string in a worksheet with another string

• print worksheets and workbooks

• protect and unprotect cells, worksheets and workbooks

• freeze and unfreeze the Excel window

• close Excel

Using combinations of these powerful functions the developer can do most of the things he or she would normally need to do without needing to master the complexities of VBA and the Excel object model. And ExcelFun functions include features that cannot otherwise be emulated from within Advantage Gen, including sophisticated error handling.

For more information and a full list of functions and examples, see the ExcelFun documentation.

To download RNXLFUN.DOC (Word 6.0 348k) click here

With the help of MailFun your application can:

• start an email (MAPI) session, optionally prompting for logon userid and password, or attach to an existing open session.

• compose and send a simple message in a single function call

• compose a complex message with multiple recipients and attachments

• retrieve addresses from the standard Address Book

• optionally invoke the standard Address Book dialog for message addressing

• send a composed message, optionally presenting it in a standard dialog box for review and change before sending

• close the open MAPI session

Using combinations of these few functions the developer can incorporate notification and workflow functionality into the Advantage Gen application

For more information and a full list of functions and examples, see the MailFun documentation.

To download RNMLFUN.DOC (Word 6.0 204k) click here

Try Them Out!

You can download trial copies of all these products (documentation and Windows Help files included). Unzip the RNALLFUN.ZIP file into a temporary directory, read README.TXT and then run SETUP.EXE.

See RNWINFUN.DOC, RNWDFUN.DOC, RNXLFUN.DOC and RNMLFUN.DOC (included in the zip files) for complete instructions on how to call the functions from within Advantage Gen Action Diagrams, and a reference guide explaining what each function does and what parameters it requires. If you wish to use the components within applications developed with other tools then you should instantiate the server with a CreateObject statement or equivalent and then work with the object as you would any OLE server.

To download the trial versions RNALLFUN.ZIP (1.5Mb) click here (includes full documentation and integrated Windows help files). WordFun, ExcelFun and MailFun support for Office 2000 and XP is included.

If you are an Advantage Gen user you can also download a demo model which shows off some of the capabilities of each of the components. Download the appropriate zip file for your version of Advantage Gen and read README.TXT. There are separate procedures within the model to demonstrate each component. To use them the components must be installed as described above.

To download the demo model, choose the appropriate link:

FUNDEMC6.ZIP (COOL:Gen 6.x, 450k)

FUNDEMC5.ZIP (COOL:Gen 5.x, 511k)

FUNDEMCG.ZIP (COOL:Gen 4.1a, 1475k)

No PTFs are required for use of these components in COOL:Gen or Advantage Gen versions 5.x or 6.x.