Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Move cursor in Excel
Message
From
15/11/2006 10:14:01
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
14/11/2006 15:27:16
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01169625
Message ID:
01169812
Views:
7
>I know I've asked this question before but I can't seem to find any reference to the answer.
>Suppose you have a spreadsheet open in excel, how do you move the cursor to the right or left?
>
>oExcel.Range('A2').select
>oExcel.ActiveCell.value = crsChart.year
>
>oExcel.MoveRight
>
>
>etc.
>
>
>Thanks
oExcel = CREATEOBJECT('Excel.Application')
WITH oExcel
 .Workbooks.Add
 .Visible = .t.
 .ActiveWorkbook.ActiveSheet.Range('A2').select
 .ActiveCell.Value = 2006
 .ActiveCell.Offset(0,1).Select
endwith
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform