Microsoft Office 2000 Developer   

What's New in Office 2000 Developer

See Also

Microsoft® Office 2000 Developer offers a multitude of new features. Many are specific to each of the applications that make up the Office 2000 suite. With the addition of Visual Basic® for Applications (VBA) in FrontPage® 2000 and Outlook 2000 the scope for Office Developer has broadened considerably. Of particular importance for this release are the features that expose solution development across the entire Office suite. These shared features hold the key to the new realm of solution opportunity enabled by Office 2000 Developer.

Office 2000 Developer is designed specifically for professional developers who are building and deploying solutions with Microsoft Office 2000. In addition to the most complete version of the Office 2000 productivity application suites, Office 2000 Developer provides the productivity tools professional developers need to build solutions faster, the integration tools to make their solutions work seamlessly with data and the Web, and the management tools to simplify deploying and managing the solutions they build with Microsoft Office.

Productivity

Professional developers demand professional tools for building solutions. Developers who build solutions with Microsoft Office need productivity tools and team-oriented tools for managing their solutions. Office 2000 Developer includes enhanced productivity tools and documentation to make developers more productive.

Code Commenter.   Create well-commented code that is easier to maintain by automatically adding comments and headers to procedures using customizable templates. For more information, see Automating Code Commenting.

Code Librarian.   Increase productivity by reusing code stored in a centralized database that developers share across teams. Includes a large database of pre-written code for standard routines for both VBA and Microsoft Visual Studio®. For more information, see Sharing and Reusing Source Code.

COM Add-in Designer.   Create stand-alone COM add-ins (DLLs) that can be used from multiple Office applications from within the VBA development environment. For more information, see Creating Add-Ins in Visual Basic for Applications.

VBA Error Handler.   Simplify and automate creating standardized error handler code for solutions that are more professional and easier to debug. Error Handler uses input dialogs that capture basic information and insert standardized error handling code using a customizable template. For more information, see Automating Error Handling.

FrontPage 2000.   Create and manage professional-quality Web sites with the leading Web site creation and management tool.

VBA Multi-Code Import/Export.   Save time and minimize cut-and-paste errors by transferring multiple code modules in and out of a project in single operation. For more information, see Sharing and Reusing VBA Objects.

Visual Basic for Applications 6.0.   Use the same editing environment for all of the Office 2000 applications.

Visual SourceSafe and Visual SourceSafe Integration with VBA.   Collaborate, share, and secure source code as a team using Visual SourceSafe. Visual SourceSafe is also integrated with VBA to provide an integrated code management system including Check In/Out, visual differencing, resource sharing, and project histories for team development, all from within the VBA environment. For more information, see Using Source Code Control.

String Editor.   Quickly and accurately build strings for SQL statements or long scripts to embed in VBA code by using the WYSIWYG string editor interface. For more information, see Working with String Variables.

Data Access

One of the most common types of Office solution is one in which data is delivered directly to the desktop. Data resides in a variety of formats and in a multitude of databases ranging from desktop to the enterprise. Developers need tools that provide easy access to data, regardless of where that data resides. Office 2000 Developer delivers tools and components that make it easy to integrate data into Office solutions and publish to the Web.

For more information about the data components available in Office 2000 Developer, see Data Connectivity.

Microsoft ActiveX Objects (ADO) Data Control.   Manages the connection through ADO/OLEDB and binds user form controls, such as text boxes, to the data source.

Data Environment Designer.   Easily connect VBA code to external data sources by creating data bound forms and controls through a visual user interface. Visually create, modify, and reuse hierarchical recordset command objects. The Data Environment visually exposes tables, views, SQL queries, and stored procedures as ADO components. Binds to multiple data sources for data aggregation and manipulation.

Data Binding Manager.   Easily connect VBA code to external data sources by creating data bound forms and controls through a visual user interface.

Data Report Designer.   Quickly build sophisticated reports by dragging elements from the Data Environment without writing any code.

Data-Bound ActiveX Controls.   Enhanced FlexGrid control displays hierarchical data, while the Data Repeater control provides an interface to repeat ActiveX controls to form an easily scrollable set of records.

Web Components.   Spreadsheet component, Microsoft Chart component, and Microsoft PivotTable component.

Deployment and Management

Office 2000 solutions should not require developers to manage code distribution without full control of each user installation. And after the solution is deployed, user assistance should be available within the solution from an intuitive interface. Office 2000 Developer provides all of the necessary tools for easily deploying and managing solutions built with Microsoft Office.

Package and Deployment Wizard.   Package applications for installation and deployment. The Package and Deployment Wizard guides you through the steps of identifying dependency files for redistribution of solutions built with Office. For more information, see Solution Distribution.

Answer Wizard Builder.   A tool for building a natural language query interface for help topics, displayed in HTML Help. For more information, see Adding Help to Your Application.

HTML Help Workshop.   Complete authoring environment for HTML Help, including a screen capture utility. For more information, see Adding Help to Your Application

Microsoft Agent SDK.   Agent Character Editor for use with Microsoft Agent and header files that define the COM interfaces to the Agent Server. For more information, see Adding Help to Your Application

Microsoft Replication Manager.   View and manage replicated Microsoft Jet databases over a network or the Internet. For more information, see the documentation included in the Replication Manager.