Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selected Range
Message
De
21/12/1999 23:36:54
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Divers
Thread ID:
00306941
Message ID:
00307132
Vues:
26
>>One last thing before I leave my friend.
>>Doesn't directly :
>>oRange = oWorkbook.ActiveSheet.Range(lcRange) work ?
>
>I hadn't tried that yet. Remember, I'm coming from 1-2-3, so this is all new to me. If you say it does, then it must< g >. Actually, I simply recalled that there were multiple parameters (top left and bottom right) mentioned. Didn't read too closely, but I'm sure that you're correct here. < vbg >
>
>>And if that cell operation is one of the things that excel could do in a snap (like all value = "somevalue", fill series, fill months, set formula etc) these are valid too :
>>oRange.AutoFill(...)
>>oRange.Value = "somevalue"
>>oRange.Formula = "=$A$1*5"
>
>Fortunately, I don't have to worry about that for now.:-)


OK :) Wellcome to "hair pullers club" :)
As John said recording a macro is a good way of "stealing" how to. It's not as straight forward all the time but 99% works. Just be carefull what an object "applies too". For a quick starter :
Range("B5:Z10")
Range("B5:G10,A6:Z7,1:1,M:M")
are valid ranges :) Try this :
ox=createobject("Excel.Application")
with ox
 .Workbooks.Add
 with .ActiveWorkBook.ActiveSheet
   .Range("B5:G10,A6:Z7,1:1,M:M").Select
 endwith
 .Visible = .t.
endwith
If you plan cells carefully you can "sign" with selection :)
Cetin
Ç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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform