Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 6.0 & MS Excel
Message
From
25/09/2002 03:21:49
 
 
To
25/09/2002 02:43:08
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00704105
Message ID:
00704110
Views:
21
Hi,
There is no VFP command which can move keys in Excel application. You need to use CreateObject( "excel.application" ) to have an object pointer to Excel application and then create a Workbook object and set the ActiveSheet within that workbook.

To go to a particular cell, say A5, you need to issue the following command

m.ExcelWorkBook.ActiveSheet.Range("a5").Select
where ExcelWorkbook points to a Excel Workbook object.

HTH,
Hitendra


>hi all,
>
>is there a command i can give from within a vfp application to move the cursor to the left / right / up / down in MS Excel ?
>
>Pls. advise.
>
>Sincere thanks in advance.
Previous
Reply
Map
View

Click here to load this message in the networking platform