My.ADVISOR.com Sign-In
ID
Password

Member Center / Sign-Up
   
SUBSCRIPTION STATUS
If you are a subscriber to this publication, sign-in to access locked articles. To subscribe or renew go to www.AdvisorStore.com.
Go to Article
Advanced Search 

MICROSOFT OFFICE INTEGRATION

Let Visual FoxPro Control Excel

Learn how to create formatted, dynamic spreadsheets from within FoxPro.

 Subscribers: Sign-in to activate download link -- ControlExcel class code and a sample program that uses the class.
By Walter Savinovich

THIS ARTICLE IS SUBSCRIBER-ONLY
To read this article you must have a current Subscription or Passport for:
DataBased.Advisor.com

If you have a correct subscription, sign-in (pink box) to view the complete article and access any Download.

Purchase or renew your Subscription or Passport at www.AdvisorStore.com.

Click this link for help with subscriber online access.

About this Article:

In this article, you'll learn about a cell-based class that lets you navigate through a spreadsheet without having to repeatedly enter cell addresses. Additionally, you can search for values, either horizontally or vertically, without regard to data type; perform basic cell formatting; read or write cell values; establish cell formulas; and perform basic page formatting.

Walter Savinovich has been programming since 1978 when he was in the U.S. Air Force. He's used BASIC, QBASIC, COBOL, Visual Basic, and xBase languages such as dBase II & III, Clipper, FORCE, and FoxPro versions 2.5 through 7. He has worked as a programmer/analyst since 1985, contracting to law firms and major corporations such as GTE, LASPCA, 20th Century Fox, and American Honda, where he is now employed. His latest project was to design and implement a computer model to represent all of American Honda's automotive distribution system.

ARTICLE INFO

Web Edition: 2005 Week 37, Doc #16878

SUBSCRIBER ONLY ARTICLE LOCKED


File: ControlExcel class code and a sample program that uses the class.
Subscribers, sign-in for Download link.

Keyword Tags: Application Development, Database Development, Development, Integration, Microsoft, Microsoft Excel, Microsoft Office, Microsoft Visual FoxPro, Software Development, Spreadsheet

Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
Portions copyright ©1983-2010 Advisor Media, LLC. All Rights Reserved.
Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, LLC in the United States and/or other countries.
Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
Hosted by Prominic.NET Website powered by
LOTUS SOFTWARE
mmx0510 SAVIW03 posted 2005-9-12 mod 03/08/2010 03:10:23 AM ztdbms/ztdbms
domino-144.advisor.com my.advisor.com 03/13/2010 04:57:52 PM