09-27-2005 09:59 AM
09-28-2005 11:46 AM
Hey Gary,
What version of MS Office does the 9.0 ActiveX control come with. I have version 11.0 here. I could get your program working on my computer but I had to reinitialize the activex control to the 11.0 control. I also had to reselect the properties. All the properties are essentially the same except Value. In this ActiveX version, I see the Value2 property (the Value property does not exist). And your method of reading and writing to the Value2 property handles 2D arrays.
If you can tell me what version of Office you are using, I will try to find a computer with that version and try your program.
Jack J.
Applications Engineer
National Instruments
09-29-2005 12:50 PM
@Jack J. wrote:
Hey Gary,
What version of MS Office does the 9.0 ActiveX control come with. I have version 11.0 here. I could get your program working on my computer but I had to reinitialize the activex control to the 11.0 control. I also had to reselect the properties. All the properties are essentially the same except Value. In this ActiveX version, I see the Value2 property (the Value property does not exist). And your method of reading and writing to the Value2 property handles 2D arrays.
If you can tell me what version of Office you are using, I will try to find a computer with that version and try your program.
Jack J.
Applications Engineer
National Instruments