Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel - find
Message
From
05/10/2004 20:31:32
 
 
To
05/10/2004 18:32:21
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00948975
Message ID:
00948994
Views:
11
After a while of trying different codes, this is it:

oexcel.Cells.Find("texttofind").Activate

I love intellisense. Hilmar, even though I have done what you suggested many times before, getting the coding right for Foxpro can take some time (at least for me). Actually, what I found helpful was in VFP8.0, create the reference to the excel object using the command window, open the document (still in the command window), and then try a bunch of variations on the macro code until you get it right (all the time checking the excel worksheet - which of course you need to set the visible property to true in order to do this).

One other point - there are a bunch of parameters after the "find" portion of the code that I have not included. This will take some more looking into to ensure that I get them right, but for now, this code works.

Paul
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform