Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selected Range
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00306941
Message ID:
00307115
Views:
31
>>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.:-)

You might want to look at some of the sample OLE code on my website. Most of it was from Randy Brown (MS) and some I've modified. You are probably also aware you can just record a macro in Excel and go with that....
John Harvey
Shelbynet.com

"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform