General information
Category:
COM/DCOM and OLE Automation
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only