Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp and Excel
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00770967
Message ID:
00770994
Views:
17
This works for me:

ObjExcel= CREATEOBJECT("Excel.Application")
ObjExcel.Workbooks.OPen(somefile)
ObjExcel.ActiveSheet.Range("B34:B300").Select
....


>Yuris thanks very much! For some reason in the following, the last range select
>selects a13:m229, the full used range of the spreadsheet, but row 13
>and below. How can I get it to select only b13:b229??
>STeve
> With o.Application
> .Range("B13").Select
> .ActiveCell.FormulaR1C1 = "=MID(RC[-1],1,10)"
> .Range("B13").Select
> .Selection.Copy
> .Range("A1").Select
>wait
> .Range("B13:B229").Select && the last range select
> EndWith
>wait
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform