OLE Objects
i'm copying a form on excel from an application built on java
platform.
what i'm tring to do is get the value of the OLEobjects copied from
the form into excel.
first i tried the code mentioned below but this will take me ages to
do as there are wround 300 optionbutton and from them i need data in
100 cells.
If ActiveSheet.HTMLOption1.Checked = "True" Then
Sheets(2).Range("A1").Value = "Yes"
If ActiveSheet.HTMLOption2.Checked = "True" Then
Sheets(2).Range("A1").Value = "No"
If ActiveSheet.HTMLOption3.Checked = "True" Then
Sheets(2).Range("A1").Value = "N/A"
then i tried
For i = 1 To ActiveSheet.OLEObjects.Count
Sheets(2).Range("A" & i).Value = ActiveSheet.OLEObjects(i).Object
Next i
it is also not helping much as the value lands up not in the order i
want.
-Thanks
|