Integration Assistant for Excel Fact Sheet



The Integration Assistant for Excel provides a new level of integration between Microsoft Business Solutions and Microsoft Excel. Using comprehensive, intuitive tools that are designed to be used by non-technical staff, your organization can easily integrate existing or new Excel business applications with Microsoft Business Solutions–Great Plains.

The Integration Assistant for Excel allows you to integrate Excel data into windows. Here, a journal entry created in Excel is integrated into General Ledger using the Build Business Object wizard.

The Integration Assistant for Excel is easy

The Integration Assistant for Excel is the easiest way to integrate Microsoft Excel business applications and reporting tools into your business management system. Non-technical users will find it easy to use the Integration Assistant for Excel. No knowledge of ODBC or the Microsoft Business Solutions–Great Plains system tables is required.

Users who are comfortable working in Excel will be able to continue using their application of choice, with information transferring cleanly into their Microsoft Business Solutions application. And, Excel workbooks can be transferred easily from workstation to workstation.

The Integration Assistant for Excel is secure. While the Integration Assistant for Excel gives you powerful integration capabilities, the internal business logic in Microsoft Business Solutions–Great Plains ensures only valid data types are passed to your business management system.

Combined with Visual Basic for Applications (VBA), Excel’s built-in customization and development environment, the Integration Assistant for Excel’s Build Desktop Application Integration Wizard provides you with a “point and click” capability to automatically generate all the VBA code required to integrate windows, fields and controls with Excel cells, spreadsheets and workbooks.

Easily integrate contents of an expense report created in Excel into the Payables Transaction Entry window.

The Integration Assistant for Excel takes advantage of industry-standard technologies

The Integration Assistant for Excel exposes specific objects, such as windows, fields and controls, to Microsoft’s Component Object Model (COM), Microsoft's standard for Windows application communication. A standard technology foundation allows Excel applications delivered with the Integration Assistant for Excel to be modified with new versions of Excel.

-----------------------

© 2002 Microsoft Corporation and Great Plains Software, Inc. All rights reserved. Microsoft, Microsoft Business Solutions and Great Plains are either registered trademarks or trademarks of Microsoft Corporation, Great Plains Software, Inc. or Microsoft Business Solutions Corporation in the United States and/or other countries. Both, Great Plains Software Inc. and Microsoft Business Solutions Corporation are wholly-owned subsidiaries of Microsoft Corporation. Functionality described herein may not be available on all versions of Microsoft Business Solutions–Great Plains products. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

-----------------------

Microsoft Business Solutions Customization Tools–Great Plains

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download