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]

Reply via email to