Hi,
I have a problem in the POI for Excel. I add an OLEObjects
"Forms.CommandButton.1" in the excel file. Please refer to the Macro
recorded.
"ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1",
Link:=False, DisplayAsIcon:=False, Left:=35.25, Top:=171, Width:=100.5,
Height:= 28.5).Select". Now I add some rows before the CommandButton,
but it does not move to next row. It still stay in Left:=35.25,
Top:=171. When we manual insert a new row in the excel file, the
CommandButton will move to the next. Please tell to me how to do use the
POI. Please help me. Thanks!
Best Regards,
Jianfeng Jiang
