Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel - find
Message
From
06/10/2004 03:56:04
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
05/10/2004 20:31:32
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00948975
Message ID:
00949054
Views:
19
Paul,
Be carefull with excel's Find. If it finds no problem. However to my experience it doesn't always Find though searched text exist. I'm not sure about the cause but as I remember if any cell content is over 255 chars it was not finding (my memory is not perfect) either with automation or manually from within excel.
Cetin


>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform