write in spreadsheet ActiveX

[ragupathi]

hi all,

i have a spreadsheet activeX control. i am able to read the it's contents by giving cell range.Likewise I need to write on it.Anyone having idea.

Thanks in advance.... 

[Ranji]

You have to specify the cell no. and data. Same way as you are reading.

[aeastet]

You will need to open the references to the correct worksheet and add the range data. see the example

 

[J.Mamakos]

If you're using activeX controls to work with Excel, you might find this VI useful - it can handle writing pretty much anything into any cell or range of cells, though formulae may have to be entered individually.

[ragupathi]

hi

Here i have attached the screen shot of the code for Read and write in activeX Spreadsheet.In that, Read is working. Wite method is not working but it doesn't shows any error.see my attachment....

[aeastet]

Try giving the starting cell only on the range input i.e C3 not C3:D6

[aeastet]

Like this