Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp, Excel, Results of Find
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Vfp, Excel, Results of Find
Miscellaneous
Thread ID:
00771394
Message ID:
00771425
Views:
10
Actually it is
** select the whole document
num_cols = o.Application.ActiveSheet.UsedRange.Columns.Count
num_rows = o.Application.ActiveSheet.UsedRange.Rows.Count
this_area = "a1:"+chr( 97 + num_cols -1)+alltrim(str(num_rows))
o.Application.Range("a1").Select

oRange = o.ActiveSheet.Range(this_area)
oRange.Cells.Find ("Date Time").Activate

see
http://groups.google.com/groups?q=vfp+excel+cells.find&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=ab2e01c172c3%24edd25be0%243def2ecf%40TKMSFTNGXA14&rnum=2
Previous
Reply
Map
View

Click here to load this message in the networking platform