1 Reply Latest reply: Aug 2, 2012 7:37 PM by Michael Solomovich RSS

    Populate data in Straight Table cell using Macro

    Sudip Sen

      Hi,

       

      I have a straight table and I need to populate one column [Stat as EX] on pressing a button using a macro. Below is the straight table.

       

      Image1.bmp

       

      I have written the the following macro.

       

      Sub CalculateSummary1

          'On error resume next

          set budget = ActiveDocument.GetSheetObject( "CH2033" )

          for RowIter = 1 to budget.GetRowCount-1

               'rif = budget.GetCell(RowIter,3).Number

               MsgBox budget.GetCell(RowIter,7).Text

               budget.SetInputFieldCell RowIter,7,"test"

           next

      End Sub

       

      Now when I am executing the code, the executing is getting stuck in the following line

       

      Image2.bmp

      Can you please help.

       

      Thanks,

       

      Sudip