Microsoft KB Archive/139051

= HOWTO: Select Cells in Excel by Using OLE Automation =

Article ID: 139051

Article Last Modified on 7/13/2004

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q139051



SUMMARY
This article shows by example how to use OLE Automation programmatically to create a Microsoft Excel worksheet, and select a range of cells.



Step-by-Step Example
  In Visual FoxPro, create and run a program (.prg file) that contains the following code: * Start of program code *     MyF3 = ON("KEY","F3") ON KEY LABEL F3 DO getout oleWorkBook = getobject("C:\BOOK1.XLS") WITH oleWorkBook.Application .Visible = .t.        .Windows(1).Visible = .t.         *Selects cells A1:D5, then makes cell D1 the active cell. .ActiveSheet.Range("A1:D5").Select ENDWITH READ EVENTS PROCEDURE getout Clear EVENTS oleExcel.Quit ON KEY LABEL F3 &MyF3 * End of program code  After Microsoft Excel starts, cells A1 through D5 should be selected. Switch back to Visual FoxPro, and press the F3 key to terminate Microsoft Excel.

Keywords: kbhowto kbinterop kbautomation kbcode KB139051

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.