Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open in specified area of excel
Message
From
10/05/2011 03:16:05
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01510133
Message ID:
01510135
Views:
56
ahh thanks borislav - I missed the select
k

>>how would i open an excel sheet scrolled to a specifc area say A-24 - i have the first part of the plan:
>>thanks K
>>
>>oXL = CREATEOBJECT("Excel.Application")
>>oXL.DisplayAlerts = .t.
>>oXL.Visible =.t.
>>oWorkbook = oXL.Workbooks.Open('MyTable.xls')
>>
>
>
>oXL.Range("A24").Select
>
Previous
Reply
Map
View

Click here to load this message in the networking platform