range setvalue

ForNow

Hi, I have been researching how to automate settting cell values in a excel spreadsheet I have seen a number of examples with the following code snipet range.Setvalue(Colevariant(ColeSafeArray &) It seem from this that the range object has a setvalue method but I have yet to find where this is documented Any help would be appreciated Thanks in advance

Lost User

I demonstrated how to use Google in my response to your question below, perhaps you could try it for yourself first.

One of these days I'm going to think of a really clever signature.

ForNow

Is the answer XPATH XPATH represents a range ? did a word that correctly

Lost User

No idea what that means, but it took one single Google search to find this article[^].

One of these days I'm going to think of a really clever signature.

ForNow

Hi Looking at that article I think what I am looking for is in that header file excel8.h or some other header with excel method,properties definations is this automatically included with office

Lost User

ForNow wrote:

is this automatically included with office

No idea, you need to read the article and any associated links for the details of how to do it.

One of these days I'm going to think of a really clever signature.