Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Move cursor in Excel
Message
From
15/11/2006 10:43:28
 
 
To
15/11/2006 10:14:01
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01169625
Message ID:
01169836
Views:
8
>>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

Thanks Cetin
That's twice you've answered this for me. I'll do a better job of filing this time.
- Don
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform