Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open in specified area of excel
Message
 
To
10/05/2011 02:55:04
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01510133
Message ID:
01510134
Views:
79
This message has been marked as the solution to the initial question of the thread.
>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform