using setvalue in excel automation
-
I've created an application which automates excel 97 (thanks to the help of the microsoft supports articles Q178749, for example). As i want to automate excel, with office 97, i need of the following library Excel8.olb. So, in my project I would fill some range in an excel worksheet, to do it i use the function setvalue, which takes (with office 97) only one parameter, a COleVariant; but now here is my problem, when i try to do the same thing with office XP( i've seen that i have to replace excel8.olb, by excel.exe) the same function need of 2 input parameters, now!!! Setvalue(COleVariant, COleVariant). One of this parameter is naturally the same that hte one i've used with excel 97, but the second one, i don't what i ve to put! I'm sorry of my approximating english, but if someone could understand me and help me to solve this problem, he will be really great thanks in advance for your help Gerald
-
I've created an application which automates excel 97 (thanks to the help of the microsoft supports articles Q178749, for example). As i want to automate excel, with office 97, i need of the following library Excel8.olb. So, in my project I would fill some range in an excel worksheet, to do it i use the function setvalue, which takes (with office 97) only one parameter, a COleVariant; but now here is my problem, when i try to do the same thing with office XP( i've seen that i have to replace excel8.olb, by excel.exe) the same function need of 2 input parameters, now!!! Setvalue(COleVariant, COleVariant). One of this parameter is naturally the same that hte one i've used with excel 97, but the second one, i don't what i ve to put! I'm sorry of my approximating english, but if someone could understand me and help me to solve this problem, he will be really great thanks in advance for your help Gerald
-
Well, I think with start of Office XP you've to call SetValue2(COleVariant). That should work.
ok i will try, and i'll tell you if it works thanks a lot
-
Well, I think with start of Office XP you've to call SetValue2(COleVariant). That should work.
sorry to be late to answer you. Just to tell you that your solution works, thanks a lot