>Is there any way using Ole automation to add
>a picture to an excel worksheet.
There certainly is. Try:
LogoFile = _SAMPLES + "TasTrade\Bitmaps\TTradeSm.bmp"
oSheet.Shapes.AddPicture(LogoFile, .T., .T., 32, 32, 72, 72)
The parameters are: Filename, LinkToPicture, SaveWithDocument, Left, Top, Width, Height. A little playing is required when you’re trying to determine the width and height of the graphic. None of the parameters are optional, so you need to know the width and height of any graphic you’re adding.
>Also, is there a way of changing a cells indent value.
Yes there is a way. Look at the AddIndent() and InsertIndent() methods and the IndentLevel property. These all belong to the Range object (a Selection object is a special form of the Range object). I haven't used these, so I can't offer much advice other than looking in the Help file.
>Finally, where can I find a list of Ole commands for VFP. the help
>file is very limited.
I agree that the Help files are limited--when you're getting started. Actually, they are pretty good if you know what you're looking for, but an alphabetical list of properties, methods, and objects doesn't seem at all helpful if you're looking for "Group of Cells" instead of "Range." So Tamar Granor and I wrote a book,
Microsoft Office Automation with Visual FoxPro, available from
www.hentzenwerke.com. It's available as a CHM file, so if you purchase it from Hentzenwerke, you'll be able to download the CHM within a few business hours. You don't have to wait for the paper book to get across the ocean! (In fact, you can purchase just the CHM version).
Hope this helps!
- della