---

Please note: This page has been retired.

We no longer sell Jumar Solutions products, please visit their web site instead:

• http://www.rainier.co.uk/products.htm

To view alternative products, please see the following:

Other information on this page is shown for historical reference only and may have changed considerably since.

---

Summary

Bundle for WordController and ExcelController by Jumar Solutions

URLs: bundle-wordcontroller-excelcontroller, bundle wordcontroller excelcontroller, bundlewordcontrollerexcelcontroller, jumar

Integrate your applications with multiple versions of Microsoft Word and Excel. Bundle for WordController and ExcelController includes both WordController and ExcelController Plus ActiveX components. Each component allows you to integrate your applications with multiple versions of the popular Microsoft Office software, solving the problems which arise when writing applications that must work across versions.

WordController

Running on top of the functionality exposed by Word, WordController detects which version is present at runtime and executes code appropriate to that version. It becomes simple to write one set of code, which can be deployed to users without worrying what version of Word they have.

WordController aggregates complex Word functionality into high-level new functions that allow Developers to manipulate Word without requiring them to understand the Word object model.

Developers who wish to integrate with Word face a major problem with regard to the different behaviour of different Word versions. Applications that are written for one version of Word do not necessarily work when run on a workstation that has a different version installed.

With the help of WordController Plus a client 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) and create new documents (optionally from templates)

Build form letters based on Word templates

Perform Word MailMerges to produce merge documents or labels based on templates

Create Word documents from data in text files

Move within and between documents, insert text, files and graphics

Apply styles and formatting

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

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

Retrieve and set document properties

Protect and unprotect sections or complete documents

Print, save, convert and close documents

Make use of Word's spell checking functionality

Run Word macros

Close Word

Excel Controller

ExcelController Plus is an is an ActiveX component which allows Developers to quickly and easily integrate their applications with multiple versions of Microsoft Excel.

Developers who wish to integrate their applications with Excel on the user machine face a major problem with regard to the different behaviour of different Excel versions. Applications which are written for one version of Excel do not necessarily work when run on a workstation which has a different version installed.

Developers do not want to have to specify that their Users have a particular version, nor do they want to revisit their applications when the next version of Excel is released. ExcelController Plus addresses these issues by adding a layer on top of the functionality exposed by Excel, detecting what version is present at runtime and executing code that will work with that version. It is now possible to write one set of code which can be deployed to users without worrying what version of Excel they have. And when the next version of Excel is released let us worry about testing its behaviour and making any changes necessary to ensure that the ExcelController functions behave in a manner as consistent as possible with the earlier versions.

With the help of ExcelController Plus a client 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. 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, pictures and formulae into cells. Retrieve data from cells.

copy data, formulae and/or formatting from one part of a workbook to another.

insert, delete and rename worksheets

create a variety of different charts

create pivot tables

run Excel macros

search and replace

print ranges, worksheets and workbooks

protect and unprotect cells, worksheets and workbooks

freeze and unfreeze the Excel window

close Excel

What's New in V5.0

This version offers Word 2003 compliance. Earlier versions do not support Word 2003. In addition there are many new functions, including extensive support for Word tables.

There is a new DLL, a new version of the sample application and updated documentation (DOC and HLP).

The new functions offered include the following:

wdcApplyTableAutoFormat

wdcApplyTableStyle

wdcCloseAllDocuments

wdcConvertTextToTable

wdcGetActiveDocumentName

wdcGetBookmarkNames

wdcGetDocumentWindowCount

wdcGetDocumentWindowName

wdcInsertBookmark

wdcInsertContentAtBookmark

wdcInsertTable

wdcRunMacroWithParameters

wdcSelectTable

wdcSelectTableCell

wdcSelectTableColumn

wdcSelectTableRow

wdcSetTableColumnWidth

wdcSetTableRowHeight

Integrate your applications with multiple versions of Microsoft Word and Excel.

Evals & Downloads: Read the WordController help file, Read the ExcelController help file, Read the WordController Documentation, Read the ExcelController Documentation

Operating System for Deployment: Windows 2000, Windows 98, Windows NT 4.0, Windows 95

Architecture of Product: 32Bit

Product Type: Component

Component Type: ActiveX DLL

Built Using: Visual Basic V5.0

Compatible Containers: Microsoft Visual Studio 6.0, Microsoft Visual Studio 97, Microsoft Visual Basic 6.0, Microsoft Visual Basic 5.0, Microsoft Visual Basic 4.0, Microsoft Visual C++ 6.0, Microsoft Visual C++ 5.0, Microsoft Visual J++ 6.0, Microsoft Visual InterDev 6.0, Microsoft Visual FoxPro 6.0, Microsoft Visual FoxPro 5.0, Microsoft ActiveX Control Pad, Microsoft Office 2000, Microsoft Office 97, Microsoft Internet Information Server 5.0, Microsoft FrontPage, Microsoft Internet Explorer 5.0, Microsoft Internet Explorer 4.0, Delphi 5.0

Product Class: Business Components

Keywords: word controller excel Microsoft Word WordController ExcelController integrate

Jumar Solutions

Product Suites Suite bundles bundle

Spreadsheet spread sheet worksheet workbook excel lotus 123 1-2-3 xls xl

Text word words processing textbox