[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Excel & VBA



PureBytes Links

Trading Reference Links

Lots of links to the following conference papers, articles and source code
to download. A nice addition to your library.

Best regards

Walter

===============================

http://www.microsoft.com/exceldev/e-a&sa.htm#vba

May 6, 1999     Microsoft Excel


Looking for Information About Office 2000?
To celebrate the release of Microsoft® Office 2000, we shifted our site over
to the Microsoft Developer Network (MSDN), the single best source for
developer information about any and all Microsoft technologies. If you want
information about developing solutions with Office 2000, go to:
http://www.msdn.microsoft.com/officedev/.

----------------------------------------------------------------------------
----
Excel Contents
Automation
VBA
Wizards/Add-ins

 ActiveX
Upgrading
Other



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

Automation
Using Microsoft Excel To Do a Bulk Mailing in Microsoft Outlook (July 31,
1997)
This paper shows you how you can use Microsoft® Excel and Microsoft OutlookT
to automate a bulk personal mailing.

Attach Custom Toolbars to Microsoft Excel Workbooks and Templates (March 6,
1998)
This article provides information about creating and using custom toolbars
in Microsoft® Excel. By attaching a custom toolbar to a workbook or template
that you plan to distribute to other users, you give those users a broadened
range of interface tools with which to accomplish their Excel tasks more
efficiently.

Give Excel the Power of Word Spelling and Grammar Checking (January 16,
1998)
This paper shows how your Excel-based solutions can benefit from the
increased power and flexibility built into the Word spelling and grammar
checker interface. You'll also learn techniques to programmatically
integrate Office 97 application dialog boxes, create and destroy custom
toolbars, and work with Excel-specific objects.




Top

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

VBA
Advanced Spreadsheet Programming with Microsoft Excel 97 (September 18,
1998)
Microsoft Excel 97 provides a very powerful development platform for
creating data analysis solutions commonly used in finance, accounting,
market research, and other fields. This paper focuses on advanced
programming topics in Microsoft Excel 97.

Converting Excel 97 Data to HTML (July 31, 1998)
This article shows you how to speed up the "Save As HTML" process in Excel.
Use VBA to automate the HTMLconvert function provided by the Internet
Assistant Wizard Add-In, saving time and preserving data formatting.

Microsoft Excel 97 Object Model Diagram (April 14, 1997)
This excerpt from the online book, Microsoft Office 97 Object Model Guide,
contains a diagram of the Microsoft Excel object model. The Object Model
Guide is included with Microsoft Office 97, Developer Edition.

Microsoft Excel Objects (February 3, 1997)
This chapter from the Microsoft Office 97/Visual Basic® Programmer's Guide
discusses the Microsoft Excel object model and working with its objects and
events. The Programmer's Guide is included with Microsoft Office 97,
Developer Edition.

Event Sequences in Microsoft Excel 97 (February 27, 1998)
This article provides an overview of Microsoft® Excel events and explores
the sequence in which they occur. Using events, you can add code that
automatically runs in response to a specific action in your application,
such as the opening, closing, or printing of a workbook. To use events
effectively, you should understand in what order they occur.

Using Dialog Box Controls on a Worksheet (April 21, 1997)
This excerpt from Microsoft Excel Visual Basic Step by Step shows you how to
make a worksheet easy to use by adding ActiveX controls.

Creating a Custom Form (March 1, 1997)
This excerpt from Microsoft Excel Visual Basic Step by Step shows you how to
create a custom form.




Top

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

Wizards / Add-ins
Creating Add-ins in Excel 97 (April 16, 1999)
This article walks you through the process of creating a simple Excel
add-in, providing detailed instructions and complete sample code.

Creating Wizards in Microsoft Office 97 (March 7, 1997)
This article discusses how to create a custom wizard in Microsoft Excel,
Word, and PowerPoint®.

Distributing Microsoft Excel 97, Word 97, and PowerPoint 97 Solutions (March
3, 1997)
This article describes how to get a Microsoft Excel 97, Word 97, or
PowerPoint 97 Visual Basic for Applications solution ready for distribution
and how to package the solution for distribution using the Setup Wizard.




Top

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

ActiveX
Using a Calendar Control in Excel (December 17, 1998)
This article describes the ActiveX® Calendar 8.0 control, tells how to
acquire it, and provides a detailed example of its use in a Microsoft®
Excel®-based project. The project illustrates how to programmatically bring
data from Microsoft Access to Excel, format it on a worksheet, and create
charts of various types by using a calendar control, DAO objects, and Visual
Basic® for Applications (VBA) Automation.

Using ActiveX Controls on a Microsoft Excel Worksheet (April 14, 1997)
This article talks about specific issues related to using ActiveX controls
on Microsoft Excel worksheets. It also describes how to register an external
ActiveX control for use on a worksheet and how to create your own custom
ActiveX control for use on a worksheet.

ActiveX Controls and Dialog Boxes (March 3, 1997)
This excerpt from the online book, Microsoft Office 97/Visual Basic®
Programmer's Guide, discusses the ActiveXT tools for creating custom dialog
boxes in Microsoft Excel 97, Word 97, and PowerPoint 97. The Programmer's
Guide is included with Microsoft Office 97, Developer Edition.




Top

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

Upgrading
Migrating Solutions to Microsoft Excel 97 (December 23, 1996)
Microsoft Excel 97 is a major upgrade of the product, with a greatly
enhanced development environment and forms package (Microsoft Forms). This
white paper provides developers both a conversion guide and reference
document for migrating solutions to Microsoft Excel 97.




Top

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

Other
Microsoft Excel 97 Developer's Kit
Link to the Microsoft® Excel® Developer's Kit on MSDN, a programming and
technical reference for everything you need to know to to develop
applications that interact with Excel.

Excel and the Web (August 26, 1998)
This article, a chapter from the Microsoft Press title Microsoft Excel 97
Developer's Handbook, explains how each of Excel's Internet features works
and how to apply it to an Internet/intranet solution.

Learn More About Microsoft Excel from the Knowledge Base (February 27, 1998)
This page lists links to a variety of Knowledge Base articles about using
ActiveX® controls in Microsoft® Excel.




Top

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



 This image means that the link points to servers that are not under
Microsoft's control. Please read our official statement regarding other
servers.


Comments? Suggestions? Write us at MSDN@xxxxxxxxxxxxxx



 © 1999 Microsoft Corporation. All rights reserved. Terms of Use.
Last Updated: April 16, 1999

Best experienced with

Click here to start.