How To Convert VBA to FoxPro for OLE Automation

MORE INFORMATION

General Notes

Variables and parameters are prefixed by a single character indicating the type of the variable or parameter as follows:

• c Character
• n Numeric
• o Object
• l Logical

Some portions of certain commands may be optional. These portions are enclosed by brackets [].

VBA has many built-in constants that may be used. However, FoxPro does not know the values of these constants. To use them in FoxPro, you need to define them as constants in the scope of your FoxPro program or form, or replace them with their appropriate values.

Object Variables

oWord is the variable used to reference Microsoft WordBasic objects, created with the following command:

   oWord = CREATEOBJECT("Word.Basic")
				

oXL is the variable used to reference Microsoft Excel application objects, created with the following command:

   oXL = CREATEOBJECT("Excel.Application")
				

oXLSheet is the variable used to reference Microsoft Excel worksheet objects, created with one of the following commands:

   oXLSheet = CREATEOBJECT("Excel.Sheet")
				

-or-

   oXLSheet = oXL.ActiveSheet
				

oXLBooks is the variable used to reference Microsoft Excel Workbooks Collection objects, created with the following command:

   oXLBooks = oXL.Workbooks
				

oXLWkBook is the variable used to reference Microsoft Excel workbook objects, created with the following command:

   oXLWkBook = oXL.ActiveWorkBook
				

Directory/File Management Statements

Add Method (Microsoft Excel)

   Syntax:

   oXLBooks.Add([cTemplate])
   oXLSheet.Add([cBefore [, cAfter [,nCount [, nType]]]])
   oXLSheet.Add([oBefore [, oAfter [,nCount [, nType]]]])

Cells Method (Microsoft Excel)

   Syntax:

   oXL.Cells([nRowIndex [, nColumnIndex]])
   oXLSheet.Cells([nRowIndex [, nColumnIndex]])

ChDir Method (Microsoft Word)

   Syntax:

   oWord.ChDir(cPath)

   Example:

   oWord.ChDir("C:\MY DOCUMENTS")

Close Method (Microsoft Excel)

   Syntax:

   oXLBooks.Close()
   oXLWkBook.Close([lSaveChanges [, cFileName [, lRouteWorkbook]]])

FileClose Method (Microsoft Word)

   Syntax:

   oWord.FileClose([nSave])

FileCloseAll Method (Microsoft Word)

   Syntax:

   oWord.FileCloseAll([nSave])

FileNew Method (Microsoft Word)

   Syntax:

   oWord.FileNew([cTemplate [, nNewTemplate]])

   Example:

   oWord.FileNew("C:\MY DOCUMENTS\MYTEMPLATE.DOT")

FileNewDefault Method (Microsoft Word)

   Syntax:

   oWord.FileNewDefault()

FileOpen Method (Microsoft Word)

   Syntax:

   oWord.FileOpen(cName [, nConfirmConversions [, nReadOnly ;
      [, nAddToMru [, cPasswordDoc [, cPasswordDot [, nRevert ;
      [, cWritePasswordDoc [, cWritePasswordDot]]]]]]]])

   Example:

   oWord.FileOpen("C:\MY DOCUMENTS\MYWORD.DOC")

Open Method (Microsoft Excel)

   Syntax:

   oXLBooks.Open(cFileName [, nUpdateLinks [, lReadOnly [, nFormat ;
      [, cPassword [, cWriteResPassword [, lIgnoreReadOnlyRecommended ;
      [, nOrigin [, cDelimiter [, lEditable [, lNotify ;
      [, nConverter]]]]]]]]]]])

   Example:

   oXLBooks.Open("C:\MY DOCUMENTS\MYSHEET.XLS")

Value Property (Microsoft Excel)

   Syntax:

   object.Value = NewValue

   Example:

   oXL.ActiveWindow.ActiveCell.Value = "Hello"