Hi Buddies,
I have a problem in Inserting TextBox into Excel sheet Range where there is
picture already inserted.
I am creating a Excel sheet from axapta using COM.
I created a Excel template in which I added Company logo at A1...M1.
I need to place some text using Text box over the Company Logo(lets say inB1).
Iam using the following code. This code is inserting text in empty cell but
not on the Image Cell.
comrange = _comobj.range('B'+ int2str(1));
range = comrange.font();
range.bold(true);
comrange.FormulaR1C1(smmQuotationTable.QuotationName);
even I tried using
compicture = _comobj.pictures();
shapeRange = compicture.Shaperange();
Textframe = shapeRange.textframe();
Characters = Textframe.characters();
Characters.text("hello");
It throws error,
Though Iam not familiar in Excel...
Can anyone have experienced in this, Please Help to solve this?
"Hands that Help is Holier than Lips that Pray"
---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total
Access, No Cost.
[Non-text portions of this message have been removed]