I can create a Range object but I cannot write clipboard data to multiple cells by setting the Value of the Range object to a clipfmt-ed string. All the cells get set to the vaule of the entire string.
What worked was creating a Range, then Select it, then Paste. I don't have any vb that I know of. Shouldn't wd 'oleinfo' tell something about the available methods and properties? I can't get that to work at all for Excel. Henry Rich bill lam wrote: > On Thu, 23 Jul 2009, Henry Rich wrote: >> I finally found >> >> http://msdn.microsoft.com/en-us/library/aa272302(office.11).aspx >> >> which lists the methods etc. But the methods under the letter S seem to >> be missing some. In particular, Select is not shown. Does anybody have >> a pointer to a complete list? > > iirc the range object is already sufficient to select cell or block of > cells. Or you meant the active cell? In the past I use the object > inspector in vb (not vb.net) to browse those methods or properties. > There should be similar facility in vs express but I might wrong. > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
